Технические ссылки для Cisco Cisco Administrative Workstation
Fields in Persistent_Variable Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBINT
If the variable is associated with an object type, the key value of the
specific object.
specific object.
ForeignKey1
AK-1 NOT NULL
DBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
ICM/IPCC Enterprise software to track the record.
RecoveryKey
PK, FK NOT NULL
DBINT
Foreign key from the User_Variable table.
UserVariableID
NULL
DESCRIPTION
The value of the variable, if it is a character string.
ValueChar
NULL
DBDATETIME
The value of the variable, if it is a date-time.
ValueDateTime
NULL
DBFLT8
The value of the variable, if it is a floating point number.
ValueFloat
NULL
DBINT
The value of the variable, if it is an integer..
ValueInt
Person Table
. To see database rules for these tables, click
Provides primary identification and authentication for all system users, including both agents
and administrators.
and administrators.
Related table
Table 144: Indexes for Person Table
index_keys
index_description
index_name
LoginNameShadow
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK2Person
FirstName, LastName
nonclustered located on PRIMARY
XIE1Person
PersonID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKPerson
Fields in Person Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NOT NULL
DBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y = Yes
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
263
Chapter 2: All Tables
Person Table