Cisco Cisco IPCC Web Option Références techniques
Table 122: Indexes for Master_Script Table
index_keys
index_description
index_name
CustomerIdShadow, EntityID,
EnterpriseName
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Master_Script
MasterScriptID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKMaster_Script
Fields in Master_Script 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
DBINT
Specifies the version of the script that is currently available for
use.
use.
CurrentVersion
FK NULL
DBINT
Identifies the customer definition associated with the script.
CustomerDefinitionID
AK-1 NOT NULL
DBINT
A “shadow” CustomerDefinitionID that allows multiple scripts
with the same EnterpriseName and different customer numbers.
with the same EnterpriseName and different customer numbers.
CustomerIdShadow
NULL
DESCRIPTION
Additional information about the script.
Description
AK-1 NOT NULL
varchar(64)
An enterprise name for the master script. The name must be
unique among all master scripts within the business entity.
unique among all master scripts within the business entity.
EnterpriseName
AK-1, FK NOT NULL
DBINT
If partitioning is enabled, indicates the business entity to which
the master script belongs.
the master script belongs.
EntityID
PK NOT NULL
DBINT
Unique identifier for this master script.
MasterScriptID
NOT NULL
DBINT
The next version number available for the script.
NextAvailableVersion
NOT NULL
DBSMALLINT
Indicates whether the script is a routing script or an
administrative script.
administrative script.
ScriptType
Media_Class Table
Information in this table defines a type of media class. This table is populated initially with
default media classes as listed in the MediaClassID field, below.
default media classes as listed in the MediaClassID field, below.
Related Table
table via the MediaClassID field.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
233
Chapter 2: All Tables
Media_Class Table