tblLVST_ApplicationCallLogFields

Table Description:

Applications may log data on a particular call directly to the ASR logs. This field stores custom information, that the integrators/users/designers may choose to log, that is not part of the platform or engine's predefined log fields. This table tracks fields that apply to an entire call.

Table structure:

Column Name	Data Type	Data Length	Default Value	See Also
ApplicationCallLogFieldID	INTEGER	N/A	N/A	N/A
CallID	INTEGER	N/A	N/A	tblLVST_Calls
stKeyID	INTEGER	N/A	N/A	tblLVST_StringTable
stValueID	INTEGER	N/A	N/A	tblLVST_StringTable

Primary Keys:

ApplicationCallLogFieldID

Foreign keys relationships:

Foreign key	Reference table	Reference key
CallID	tblLVST_Calls	CallID

Foreign key	Reference table	Reference key
stKeyID	tblLVST_StringTable	StringID

Foreign key	Reference table	Reference key
stValueID	tblLVST_StringTable	StringID

Column Descriptions and Constraints:

ApplicationCallLogFieldID

Description:Autoincrementing primary key
Constraint Name:N/A
Constraint Description:N/A

CallID

Description:Foreign key reference to tblLVST_Calls. Identifies the source call
Constraint Name:N/A
Constraint Description:N/A

stKeyID

Description:Foreign key reference to tblLVST_StringTable. Identifies the key for this log field.
Constraint Name:N/A
Constraint Description:N/A

stValueID

Description:Foreign key reference to tblLVST_String. Identifies the value for this log field.
Constraint Name:N/A
Constraint Description:N/A

Table Constraints:

Constraint Name: notexist
Constraint Description: An entry in this table is a unique setting for log field so there can be only one particular CallID, KeyID, and ValueID.
Columns related: CallID, stKeyID, stValueID