tblLVST_ApplicationLogFields

Table Description:

Applications may log data on a particular interaction directly to the ASR log field. 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 a single interaction, and makes them available for searching.

Table structure:

Column Name	Data Type	Data Length	Default Value	See Also
ApplicationLogFieldID	INTEGER	N/A	N/A	N/A
InteractionID	INTEGER	N/A	N/A	tblLVST_CallInteractions
stKeyID	INTEGER	N/A	N/A	tblLVST_StringTable
stValueID	INTEGER	N/A	N/A	tblLVST_StringTable

Primary Keys:

ApplicationLogFieldID

Foreign keys relationships:

Foreign key	Reference table	Reference key
InteractionID	tblLVST_CallInteractions	InteractionID

Foreign key	Reference table	Reference key
stKeyID	tblLVST_StringTable	StringID

Foreign key	Reference table	Reference key
stValueID	tblLVST_StringTable	StringID

Column Descriptions and Constraints:

ApplicationLogFieldID

Description: Autoincrementing primary key
Constraint Name:
Constraint Description:

InteractionID

Description:Foreign key reference to tblLVST_CallInteractions. Identifies the source call and interaction.
Constraint Name:
Constraint Description:

stKeyID

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

stValueID

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

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:InteractionID, stKeyID, stValueID