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 Key	Reference Table	Reference Key
CallID	tblLVST_Calls	CallID
stKeyID	tblLVST_StringTable	StringID
stValueID	tblLVST_StringTable	StringID

Column Descriptions and Constraints:

Column	Description	Constraint Name	Constraint Description
ApplicationCallLogFieldID	Autoincrementing primary key	N/A	N/A
CallID	Foreign key reference to tblLVST_Calls. Identifies the source call.	N/A	N/A
stKeyID	Foreign key reference to tblLVST_StringTable. Identifies the key for this log field.	N/A	N/A
stValueID	Foreign key reference to tblLVST_String. Identifies the value for this log field.	N/A	N/A

Table Constraints:

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