Cisco Cisco IPCC Web Option Technical References

Page of 620
 (via LocalID)
Table 176: Indexes for Script_Cross_Reference Table
index_keys
index_description
index_name
ForeignKey
nonclustered located on PRIMARY
XIE1Script_Cross_Reference
ScriptID, LocalID
clustered, unique, primary key
located on PRIMARY
XPKScript_Cross_Reference
Fields in Script_Cross_Reference Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
IE-1 NOT NULL
DBINT
Foreign key from a configuration table. This is always an ID field.
ForeignKey
PK NOT NULL
DBINT
Local ID in script that cross references a foreign key field in one of
the other configuration tables.
LocalID
PK, FK, NOT NULL
DBINT
Foreign key from Script table.
ScriptID
NOT NULL
DBSMALLINT
Type of table to which the ForeignKey applies. To see the possible
values, click 
TargetType
Script_Data Table
This table is part of the 
It contains a binary version of a routing script or administrative script. A long script may require
multiple Script_Data rows.
The Script Editor automatically maintains the Script_Data table.
Related tables
Table 177: Indexes for Script_Data Table
index_keys
index_description
index_name
ScriptID, RowOrder
clustered, unique, primary key
located on PRIMARY
XPKScript_Data
Fields in Script_Data Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBINT
Ordinal number of the rows that apply to a specific script.
RowOrder
NULL
image
Internal script representation.
ScriptData
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
319
Chapter 2:  All Tables
Script_Data Table