Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 548
   
2-416
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2      Table Details
Trunk Table
Trunk Table
Each row describes a trunk associated with a peripheral. Trunks are grouped by the Trunk Group table.
Use the Trunk bulk configuration tools to add, update, and delete Trunk records.
Related tables:
 (via TrunkGroupID)
Table 2-373 Trunk Table Constraints
Constraint
Field Name(s)
PK
TrunkID
AK-1
TrunkGroupID
TrunkNumber
FK
TrunkGroupID
Table 2-374 Trunk Table
Field Name
Description
Data Type
Keys and 
Null Option
ChangeStamp
Incremented when the record is changed in the 
central database.
CHANGESTAMP
NOT NULL
CircuitProvider
The carrier that provides the circuit.
VNAME32
NULL
TrunkGroupID
Foreign key from the Trunk Group table.
DBINT
AK-1, FK
NOT NULL
TrunkID
A unique identifier for the trunk.
DBINT
PK
NOT NULL
TrunkNumber
Trunk number as understood by the peripheral.
DBINT
AK-1
NOT NULL
TrunkType
Type of trunk: 
1 = Local C.O.
2 = Foreign Exchange
3 = WATS
4 = DID/DNIS
5 = PRI
6 = Tie Line
7 = Interflow
DBSMALLINT
NOT NULL