Cisco Cisco IPCC Web Option Technical References

The combination of FirstName and LastName is an inversion key for the Agent table. While
this key value is not necessarily unique, it is a convenient way to locate specific agents. This
table lists the types of keys and the codes used for them in the ICM database.

Consists of one or more fields that have a unique value for each record in
the table.

PK

Primary key

A unique key that can be used instead of the primary key to locate a specific
record.

AK

Alternate key

A primary key from one table that appears in a second table. A foreign key
that establishes a one-to-one relationship is always unique. A foreign key
that establishes a one-to-many relationship is not unique.

FK

Foreign key

A key that does not necessarily have a unique value, but can be used to locate
a group of records within the table.

IE

Inversion key

In the section 

, the codes from this table are used to identify key fields in

each table. If a table has more than one key of the same type, then numbers are attached to the
codes. For example, if a table has two alternate keys, then the fields that participate in the first
are marked AK1 and the fields that participate in the second are marked AK2.

Each field is also marked as either NULL (meaning the NULL value is valid for the field) or
NOT NULL (meaning the NULL value is not valid).

Reserved Fields

Some fields in the database are marked as reserved. This means that ICM software or the database
manager might use the field, but it has no external meaning. You must not modify any field
marked as reserved.

Field Applicability

Unless specifically indicated otherwise, table fields apply to both ICM and IPCC.

Data Types

This table describes the data types used for fields in the ICM/IPCC database.

Consists of one or more fields that have a unique value
for each record in the table.

NOT NULL

int

CHANGESTAMP

Up to 1 character. The value 1 is the storage size.

NOT NULL

char(1)

DBCHAR

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.

datetime

datetime

DBDATETIME

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