Cisco Cisco IPCC Web Option Technical References

Page of 620
Keys and Null Option:
Data Type:
Description:
Field Name:
NULL
image
Internal real time data for the script.
ScriptMeters
Script_Table Table
This table is part of the 
Each row describes a table from an external database that can be queried from within routing
scripts or administrative scripts using the optional Gateway SQL feature.
Use ICM Configuration Manager to add, update, and delete Script_Table records.
Related tables
 (via ScriptTableID)
Table 182: Indexes for Script_Table Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
XAK1Script_Table
ScriptTableID
clustered, unique, primary key
located on PRIMARY
XPKScript_Table
Fields in Script_Table Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBSMALLINT
Indicates how to query data from the table. Currently only SQL (1)
is supported.
AccessType
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULL
DESCRIPTION
Further information about the external table.
Description
AK-1 NOT NULL
VNAME32
A name that is unique among all script tables defined in the ICM
database.
EnterpriseName
PK NOT NULL
DBINT
A unique identifier for the external table.
ScriptTableID
NULL
DESCRIPTION
The path of the database table as reached by Side A of the ICM
Central Controller.
SideA
NULL
DESCRIPTION
The path of the database table as reached by Side B of the ICM
Central Controller.
SideB
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
323
Chapter 2:  All Tables
Script_Table Table