McDewey

Description Code Key Type Consists of one or more fields that have a unique value for each record in the table. By default, the primary key is the clustered key for the table. PK Primary key A unique key, other than the primary key, that you can use 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 By default, all keys are on the PRIMARY file group for the database. Microsoft SQL Server always creates the PRIMARY file group as the default file group. Note 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 in the first are "AK1" and the fields in the second are "AK2." Each field is marked as either NULL (meaning that NULL is a valid value) or NOT NULL (meaning that NULL is not valid). Reserved Fields Some fields in the database are marked as reserved. This means that system 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 Unified ICM and Unified CCE. Data Types This table describes the data types used for fields in the Unified ICM and Unified CCE database. Description Null Option Default MS SQL Server Data Type Unified ICM and Unified CCE Defined Data Type 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 Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 4 Introduction Reserved Fields