McDewey

Table 241: Fields in the Machine_Host_Attributes Table Keys and NULL Option Data Type Description Name NOT NULL VARCHAR(255) Name of the attribute Attributename NOT NULL VARCHAR(512) Value of the attribute AttributeValue NULL DBSMALLINT Is used to segregate the attributes type if required for future use Category NOT NULL DBINT Foreign key from the MachineHost MachineHostID NOT NULL DBINT MachineHostAttributeID Machine_Service This table stores connection information for each service running on a host. The parent is Machine_Host. Table 242: Fields in Machine_Service Table Keys and NULL Option Data Type Description Name NOT NULL DBCHAR Whether the record was autogenerated by the system. Once a user modifies a record, the value is set to False ('N'). AutoGenerated NULL DESCRIPTION The description. Description NULL varbinary(max) An optional encrypted password required for some Gateway operations. EnablePassword NOT NULL DBINT The Service IP Address (foreign key to the Machine_Address table). MachineAddressID NULL DBINT The foreign key to the Machine_Connection_Profile table. MachineConnectionProfileID NOT NULL DBINT The parent of the table (foreign key to the Machine_Host table). MachineHostID NOT NULL DBINT The database ID of the row. MachineServiceID Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 298 All Tables Machine_Service