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 Key	Reference Table	Reference Key
InteractionID	tblLVST_CallInteractions	InteractionID
stKeyID	tblLVST_StringTable	StringID
stValueID	tblLVST_StringTable	StringID

Column Descriptions and Constraints:

Column	Description	Constraint Name	Constraint Description
ApplicationLogFieldID	Autoincrementing primary key	N/A	N/A
InteractionID	Foreign key reference to tblLVST_CallInteractions. Identifies the source call and interaction.	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_StringTable. 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.	InteractionID, stKeyID, stValueID