Cisco Cisco E-Mail Manager Unity Integration Option Riferimenti tecnici
2-204
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Master_Script Table
Master_Script Table
Each row identifies a routing script or an administrative script. Each master script might have several
versions. Information about each version is stored in the Script table.
versions. Information about each version is stored in the Script table.
A new Master_Script record is created whenever you save a script with a new name in the Script Editor.
Table 2-210 Master_Script Table Constraints
Constraint
Field Name(s)
PK
MasterScriptID
AK-1
CustomerIdShadow
EnterpriseName
EntityID
EnterpriseName
EntityID
FK
CustomerDefinitionID
EntityID
EntityID
Table 2-211 Master_Script 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
CurrentVersion
Specifies the version of the script that is currently
available for use.
available for use.
DBINT
NOT NULL
CustomerDefinitionID
Identifies the customer definition associated with
the script.
the script.
DBINT
FK
NULL
CustomerIdShadow
A “shadow” CustomerDefinitionID that allows
multiple scripts with the same EnterpriseName
and different customer numbers.
multiple scripts with the same EnterpriseName
and different customer numbers.
DBINT
AK-1
NOT NULL
Description
Additional information about the script.
DESCRIPTION
NULL
EnterpriseName
An enterprise name for the master script. The
name must be unique among all master scripts
within the business entity.
name must be unique among all master scripts
within the business entity.
varchar(64)
AK-1
NOT NULL
EntityID
If partitioning is enabled, indicates the business
entity to which the master script belongs.
entity to which the master script belongs.
DBINT
AK-1, FK
NOT NULL
MasterScriptID
Unique identifier for this master script.
DBINT
PK
NOT NULL
NextAvailableVersion
The next version number available for the script.
DBINT
NOT NULL
ScriptType
Indicates whether the script is a routing script or
an administrative script.
an administrative script.
DBSMALLINT
NOT NULL