Technical References

Keys and Null
Option:
Data Type:Description:Field Name:
NOT NULLDBSMALLINT
The type of client the controller provides the interface for.
ClientType
NULLvarchar(255)
String containing information, such as logon information, specific
to the interface controller device. For example: -rtuser UserName
-rtpswd Password
ConfigParam
NOT NULLDBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y = Yes
• N = No
NULLDESCRIPTION
Additional information about the controller.
Description
AK-1 NOT NULLVNAME32
An enterprise name for the controller. This name must be unique
for all logical controllers in the enterprise.
EnterpriseName
PK NOT NULLDBSMALLINT
Unique identifier for this logical controller.
LogicalControllerID
NOT NULLDBSMALLINT
The Interface Controller type:
LogicalControllerType
• 2 = PG
• 3 = NIC
NULLvarchar(32)
The address for CTI Server as IP:port (either in dotted-numeric
or name format).
PrimaryCtiAddress
NULLvarchar(32)
The address for the backup CTI Server as IP:port (either in
dotted-numeric or name format)
SecondaryCtiAddress
Machine_Info
This table is in the System category (page 460). To see database rules for these tables, click here
(page 511).
This table lists the machines in Simplified Configuration deployments.
Table 121: Indexes for Machine_Info Table
index_keysindex_descriptionindex_name
MachineNamenonclustered, unique, unique key
located on PRIMARY
XAK1MachineName
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
231
Chapter 2: All Tables
Machine_Info