Cisco Cisco IPCC Web Option Technical References
2-199
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Script_Table_Column Table
Related tables:
Script Table Column (via ScriptTableID)
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:
Script Table (via ScriptTableID)
Description
Further information about the external table.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL
Table 2-162 Script Table Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-163 Script_Table_Column Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ScriptTableColumnID
A unique identifier for this script table column.
int
PK, NOT NULL
ScriptTableID
Foreign key from the Script_Table table.
int
AK1, FK, NOT
NULL
NULL
ColumnName
The name of the column in the external database.
varchar(32)
AK1, NOT
NULL
NULL
Description
Additional information about the column.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL