tblLVST_CallInteractions
Table Description:
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.
Table structure:
| Column Name |
Data Type |
Data Length |
Default Value |
See Also |
| InteractionID |
INTEGER |
N/A |
N/A |
N/A |
| CallID |
INTEGER |
N/A |
N/A |
tblLVST_Calls |
| Interaction |
VARCHAR |
900 |
N/A |
N/A |
| SeqNo |
INTEGER |
N/A |
N/A |
N/A |
| stEvent |
INTEGER |
N/A |
N/A |
tblLVST_StringTable |
| stPlatform |
INTEGER |
N/A |
N/A |
tblLVST_StringTable |
| 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 |
Primary Keys:
| Foreign Key |
Reference Table |
Reference Key |
| CallID |
tblLVST_Calls |
CallID |
| stEvent |
tblLVST_StringTable |
StringID |
| stPlatform |
tblLVST_StringTable |
StringID |
Column Descriptions and Constraints:
| Column |
Description |
Constraint Name |
Constraint Description |
| InteractionID |
Autoincrementing primary key for table. |
N/A |
N/A |
| CallID |
Foreign key reference to tblLVST_Calls. Each callSRE has a CallID in the database, this
tells which CallSRE this interaction belongs to
|
N/A |
N/A |
| Interaction |
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.
|
N/A |
N/A |
| SeqNo |
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.
|
N/A |
N/A |
| stEvent |
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.
|
N/A |
N/A |
| stPlatform |
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.
|
N/A |
N/A |
| Channel |
Determines which channel the decode takes place |
N/A |
N/A |
| CTime |
the time when this interaction takes place |
N/A |
N/A |
| Milliseconds |
the milliseconds when this interaction takes place |
N/A |
N/A |
| InstanceTime |
determines when this interaction takes place in SQL TIMESTAMP |
N/A |
N/A |
Table Constraints:
| Constraint Name |
Constraint Description |
Columns Related |
| N/A |
UNIQUE |
N/A |