tblLVST_CallInteractions tracks interactions between a system and a user. This includes call pickups, hangups, speech events, DTMF events, and transfers. Each interaction is stored along with its order in the original session. This table, combined with tblLVST_Calls, is the key identifier in separating out the information contained in nearly every other table in the database.
| Column Name | Data Type | Data Length | Default Value | See Also |
|
InteractionID |
INTEGER |
N/A/td> |
N/A |
N/A |
|
CallID |
INTEGER |
N/A |
N/A> |
|
|
Interaction |
VARCHAR |
900 |
N/A |
N/A |
|
SeqNo |
INTEGER |
N/A |
N/A |
N/A |
|
stEvent |
INTEGER |
N/A |
N/A |
|
|
stPlatform |
INTEGER |
N/A |
N/A |
|
|
Channel |
VARCHAR |
900 |
N/A |
N/A |
|
CTime |
INTEGER |
N/A |
N/A |
N/A |
|
Milliseconds |
INTEGER |
N/A |
N/A |
N/A |
|
InstanceTime |
TIMESTAMP |
N/A |
N/A |
N/A |
| Foreign key | Reference table | Reference key |
|
CallID |
tblLVST_Calls |
CallID |
| Foreign key | Reference table | Reference key |
|
stEvent |
tblLVST_StringTable |
StringID |
| Foreign key | Reference table | Reference key |
|
stPlatform |
tblLVST_StringTable |
StringID |
InteractionID
Description: Autoincrementing primary key for table.
Constraint Name:
Constraint Description:
CallID
Description:Foreign key reference to tblLVST_Calls. Each callSRE has a CallID in the database, this tells which CallSRE this interaction belongs to
Constraint Name:N/A
Constraint Description:N/A
Interaction
Description:The label for this interaction. Since interaction labels aren't unique, the real key is the interaction *plus* the GUID from tblLVST_Calls. The current scheme expects to see that the interaction label be CSP_xxx_xxx, where the first group of 'xxx' is the number of seconds since epoch, and the second group of 'xxx' is the milliseconds. The two items together should be the same as the converted Created column.
Constraint Name:N/A
Constraint Description:N/A
SeqNo
Description:Which sequence number this interaction occurred as. Typically, session start is sequence 0, and then some number of interactions, and then call end. SeqNo indicates where in the order of interactions this interaction took place.
Constraint Name:N/A
Constraint Description:N/A
stEvent
Description:What kind of event is this interaction? The current items understood are Session Start (START_DECODE_SEQ), Session End (END_DECODE_SEQ), Speech (SRE), DTMF Response (DTMF) Decode failure (SRE_FAIL), and Transfer (TRANSFER). New ones can be created.
Constraint Name:N/A
Constraint Description:N/A
stPlatform
Description: Link to a string describing the platform this interaction took place on. This is provided per-interaction to enable speech decodes that take place across multiple engines/platforms.
Constraint Name:N/A
Constraint Description:N/A
Channel
Description: Determines which channel the decode takes place
Constraint Name:N/A
Constraint Description:N/A
CTime
Description: the time when this interaction takes place
Constraint Name:N/A
Constraint Description:N/A
Milliseconds
Description: the milliseconds when this interaction takes place
Constraint Name:N/A
Constraint Description:N/A
InstanceTime
Description: determines when this interaction takes place in SQL TIMESTAMP
Constraint Name:N/A
Constraint Description:N/A
Constraint Name: notexist
Constraint Description: UNIQUE
Columns related: