Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-38
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Application_Path_Member Table
Application_Path_Member Table
Defines the Media Routing Domains (MRDs) that use a particular application path.
Related tables:
Application Path (via ApplicationPathID)
Media Routing Domain (via MRDomainID)
Peripheral (via PeripheralID)
Application_Path_Real_Time Table
Provides real-time status and connection data for application paths.
Table 2-23 Application_Path_Member Table
Field Name
Description
Data Type
Keys and Null
Option
Option
PeripheralID
Link to the Peripheral table.
smallint
PK1, NOT
NULL
NULL
MRDomainID
The MRD identifier for this application path
member.
member.
int
PK2
NOT NULL
NOT NULL
ApplicationPathID
The application path identifier for this application
path member.
path member.
int
FK, IE1
NOT NULL
NOT NULL
Table 2-24 Application_Path_Real_Time Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ApplicationPathID
The application path identifier for this application
path member.
path member.
int
PK,
NOT NULL
NOT NULL
DateTime
The date and time when the data in this table was
last updated.
last updated.
datetime
NOT NULL
OnLineDateTime
The date and time at which the application instance
associated with this application path established
connection to the CTI Server.
associated with this application path established
connection to the CTI Server.
datetime
NULL
OnLine
Indicates whether or not the application path is
currently on-line:
currently on-line:
Y = yes, on-line
N = no, not on-line.
N = no, not on-line.
char(1)
NULL
Text1
Application-specific strings.
varchar(40)
NULL
Text2
Application-specific strings.
varchar(40)
NULL
Text3
Application-specific strings.
varchar(40)
NULL
Text4
Application-specific strings.
varchar(40)
NULL
Text5
Application-specific strings.
varchar(40)
NULL