Cisco Cisco IP Contact Center Release 4.6.1 Technical References
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
TrunkNumber
FK
TrunkGroupID
Table 2-374 Trunk 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
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
2 = Foreign Exchange
3 = WATS
4 = DID/DNIS
5 = PRI
6 = Tie Line
7 = Interflow
DBSMALLINT
NOT NULL