tblLVST_InterKeyValue is a fast search index. A number of items are used in multiple searches, so rather than run a separate query for each filter request, and join several tables, this allows the user to do all the queries at once, and insert them into this table. The LVST GUI automatically queries this table to fill out the Filter/Value drop-down boxes. Any modifications done here (for example, adding a [key, value] pair) will be represented in the Tuner, in the next database opened, so you can add custom search fields here, quite easily.
| Column Name | Data Type | Data Length | Default Value | See Also |
|
InterKeyValueID |
INTEGER |
N/A |
N/A |
N/A |
|
stKeyID |
INTEGER |
N/A |
N/A |
|
|
stValueID |
INTEGER |
N/A |
N/A |
InterKeyValueID
| 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 |
InteractionID
Description:Foreign key into tblLVST_CallInteractions. Identifies the interaction this request belongs to.
Constraint Name:N/A
Constraint Description:N/A
InterKeyValueID
Description:Autoincrementing primary key
Constraint Name:N/A
Constraint Description:N/A
stKeyID
Description:Foreign key to tblLVST_StringTable. Identify the key in the string table.
Constraint Name:N/A
Constraint Description:link
stValueID
Description:Foreign key to tblLVST_StringTable. Identify the value in the string table.
Constraint Name:N/A
Constraint Description:link
Constraint Name:notexist
Constraint Description:There's no reason to have more than one entry of a (key, value) pair for a given interaction. The UNIQUE constraint will keep the query results nice and
Columns related:InteractionID, KeyID, ValueID