Cisco Cisco IPCC Web Option Technical References
1-6
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 1 Introduction
General Concepts
Data Types
Table 1-2 describes the data types used for fields in the ICM database.
Table 1-2
Field Data Types
ICM Defined
Data Type
Data Type
MS SQL Server
Data Type
Data Type
Null Option
Default
Default
Description
CHANGESTAMP
int
NOT
NULL
NULL
Consists of one or more fields that have a unique
value for each record in the table.
value for each record in the table.
DBCHAR
char(1)
NOT NULL Up to 1 character. The value 1 is the storage size.
DBDATETIME
datetime
NULL
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.
four-byte integers (eight bytes total): days before or
since January 1, 1900 and seconds since midnight.
DBFLT4
real
NULL
A four-byte floating-point value (7-digit precision).
DBFLT8
float
NULL
An eight-byte floating-point value (15-digit
precision).
precision).
DBINT
int
NULL
A four-byte integer value between -2,147,483,648
and 2,147,483,647.
and 2,147,483,647.
DBSMALLDATE
smalldatetime
NULL
A date and time accurate to the minute. Stored as two
unsigned two-byte integers (four bytes total):
number of days since January 1, 1900 and minutes
since midnight.
unsigned two-byte integers (four bytes total):
number of days since January 1, 1900 and minutes
since midnight.
DBSMALLINT
smallint
NULL
A two-byte integer value between -32,768 and
32,767.
32,767.
DBTINYINT
tinyint
NOT NULL A one-byte integer value between 0 and 255.
DESCRIPTION
varchar(255)
NULL
Up to 255 characters. The value 255 is the storage
size.
size.
GLOBALID
varchar(32)
NULL
Up to 32 characters. The value 32 is the storage size.
TELNO
char (10)
NULL
Up to 10 characters. The value 10 is the storage size.
VNAME32
varchar(32)
NULL
Up to 32 characters. The value 32 is the storage size.
VTELNO10
varchar(10)
NULL
Up to 10 characters. The value 10 is the storage size.
VTELNO20
varchar(20)
NULL
Up to 20 characters. The value 20 is the storage size.
undefined
char(4)
NULL
Up to 4 characters. The value 4 is the storage size.
undefined
image
NULL
Up to 2,147,483,647 bytes of binary data. The
storage size is determined by the length of the data.
storage size is determined by the length of the data.
undefined
varchar(2)
NOT NULL Up to 2 characters. The value 2 is the storage size.
undefined
varchar(30)
NOT NULL Up to 30 characters. The value 30 is the storage size.
undefined
varchar(64)
NOT NULL Up to 64 characters. The value 64 is the storage size.
undefined
varchar(100)
NOT NULL Up to 100 characters. The value 100 is the storage
size.
undefined
varchar(n)
NULL
Up to n characters. The value n is the storage size.