Cisco Cisco Administrative Workstation Technical References
2-243
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Physical_Interface_Controller Table
Physical_Interface_Controller Table
Describes a single Network Interface Controller (NIC) or Peripheral Gateway (PG). A duplexed NIC has
two entries in the Physical Interface Controller table and a single entry in the Logical Interface
Controller table. A pair of duplexed PGs share a single entry in the Physical Interface Controller table.
two entries in the Physical Interface Controller table and a single entry in the Logical Interface
Controller table. A pair of duplexed PGs share a single entry in the Physical Interface Controller table.
Use the PG or NIC Explorer tools to add, update, and delete Physical_Interface_Controller records.
Related tables:
(via LogicalControllerID)
(via PhysicalControllerID)
(via PhysicalControllerID)
Table 2-256 Physical_Interface_Controller Table Constraints
Constraint
Field Name(s)
PK
PhysicalControllerID
AK-1
EnterpriseName
FK
LogicalControllerID
IE-1
LogicalControllerID
Table 2-257 Physical_Interface_Controller 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
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
DBCHAR
NOT NULL
Description
Additional information about the controller.
DESCRIPTION
NULL
EnterpriseName
An enterprise name for the controller. This name
must be unique for all physical controllers in the
enterprise.
must be unique for all physical controllers in the
enterprise.
VNAME32
AK-1
NOT NULL
LogicalControllerID
Foreign key from Logical Interface Controller
table.
table.
DBSMALLINT
FK, IE-1
NOT NULL
PhysicalControllerID
Unique identifier for this physical controller.
DBSMALLINT
PK
NOT NULL