Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References

 gives the data type for each field in each table.

The following sections introduce the major tables in the ICM database and show their relationships.

For details about all tables, see 

 For more information about the relationships 

among all tables, see the ICM on-line Schema Help.

int

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

real

A four-byte floating-point value (7-digit precision).

smalldatetime

A date and time accurate to the minute. Stored as two unsigned 
two-byte integers (four bytes total): number of days since Janu-
ary 1, 1900 and minutes since midnight.

smallint

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

tinyint

A one-byte integer value between 0 and 255.

varbinary(n)

Up to n bytes of binary data. The storage size is determined by 
the length of the data.

varchar(n)

Up to n characters. The storage size depends on the length of the 
data.