Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-311
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Script_Table_Column Table
Script_Table_Column Table
Each row describes a column in a table from an external database that can be queried from within routing
scripts or administrative scripts.
scripts or administrative scripts.
Use ICM Configuration Manager to add, update, and delete Script_Table_Column records.
Related tables:
(via ScriptTableID)
Table 2-331 Script_Table_Column Table Constraints
Constraint
Field Name(s)
PK
ScriptTableColumnID
AK-1
ColumnName
ScriptTableID
ScriptTableID
FK
ScriptTableID
Table 2-332 Script_Table_Column Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
ColumnName
The name of the column in the external database.
VNAME32
AK-1
NOT NULL
Description
Additional information about the column.
DESCRIPTION
NULL
ScriptTableColumnID
A unique identifier for this script table column.
DBINT
PK
NOT NULL
ScriptTableID
Foreign key from the Script_Table table.
DBINT
AK-1, FK
NOT NULL