Technical References

A four-byte ﬂoating-point value (7-digit precision).NULLrealDBFLT4

An eight-byte ﬂoating-point value (15-digit precision).ﬂoatﬂoatDBFLT8

A date and time accurate to the minute. Stored as two

unsigned two-byte integers (four bytes total): number

smalldatetimesmalldatetimeDBSMALLDATE

of days since January 1, 1900 and minutes since

midnight.

A four-byte integer value between -2,147,483,648 and

2,147,483,647.

NULLintDBINT

A two-byte integer value between -32,768 and 32,767.NULLsmallintDBSMALLINT

Up to 255 characters. The value 255 is the storage size.NULLvarchar(255)DESCRIPTION

A one-byte integer value between 0 and 255.NOT NULLtinyintDBTINYINT

Up to 10 characters. The value 10 is the storage size.NULLchar (10)TELNO

Up to 32 characters. The value 32 is the storage size.varchar(32)varchar(32)VNAME32

Up to 10 characters. The value 10 is the storage size.NULLvarchar(10)VTELNO10

Up to 20 characters. The value 20 is the storage size.NULLvarchar(20)VTELNO20

Up to n characters. The value n is the storage size.NULLchar(n)char(n)

Up to n characters. The value n is the storage size.NULLvarchar(n)varchar(n)

Up to 2,147,483,647 bytes of binary data. The storage

size is determined by the length of the data.

NULLimageimage

A date and time accurate to the second. Stored as two

four-byte integers (eight bytes total): days before or

since January 1, 1900 and seconds since midnight.

NULLdatetimedatetime

A date and time accurate to the minute. Stored as two

unsigned two-byte integers (four bytes total): number

NULLsmalldatetimesmalldatetime

of days since January 1, 1900 and minutes since

midnight.

Partitioning

Customers who enable partitioning can refer to the ICM Administration Guide for Cisco ICM

Enterprise Edition for information about security related to partitioning.

Real-time and Historical Data

ICM/IPCC software maintains real-time and historical status information about certain objects

in the system such as service, skill groups, routes, and scripts.

For example, the Route Real Time table contains real-time information about each route. The

Route Five Minute and Route Half Hour tables contain historical information about each route.

The Route Real Time table contains one row for each route. (It has a one-to-one relationship

with the Route table.) The Route Half Hour table contains many rows for each route—ICM/IPCC

software adds an additional row for each route every half hour. (It has a one-to-many relationship

with the Route table.)

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)

Chapter 1: Introduction

Real-time and Historical Data