tblLVST_Audio

Table Description:

This table stores information about the audio data for the interactions. Included are PROMPT, RAW (unprocessed), and POST-PROCESSED audio data. Note that none of these _must_ be present, but if one is missing, that particular audio won't be available. For the Tuner GUI, this means that the audio won't show up in the Audio Control at the bottom of the main window. For efficiency, the audio data itself is stored in an encoded format in tblLVST_AudioData. This arrangement prevents having to load the (usually) very large audio data tables when the user simply wants information about the audio.

Table structure:

Column Name	Data Type	Data Length	Default Value	See Also
AudioID	INTEGER	N/A	N/A	N/A
InteractionID	INTEGER	N/A	N/A	tblLVST_CallInteractions
cAudioType	INTEGER	N/A	N/A	tblLVST_Audio_cAudioType
cAudioFormat	INTEGER	N/A	N/A	tblLVST_Audio_cAudioFormat
AudioLengthInMs	FLOAT	N/A	N/A	N/A
AudioLengthInBytes	INTEGER	N/A	N/A	N/A
EncodedAudioLengthInBytes	INTEGER	N/A	N/A	sqlite_encode_binary sqlite_decode_binary

Primary Keys:

AudioID

Foreign keys relationships:

Foreign key	Reference table	Reference key
InteractionID	tblLVST_CallInteractions	InteractionID

Foreign key	Reference table	Reference key
cAudioType	tblLVST_Audio_cAudioType	ConstantValue

Foreign key	Reference table	Reference key
cAudioFormat	tblLVST_Audio_cAudioFormat	ConstantValue

Column Descriptions and Constraints:

AudioID

Description: Primary key for this table
Constraint Name: N/A
Constraint Description: N/A

InteractionID

Description:Foreign key to tblLVST_CallInteractions. Identifies the interaciton this audio data belongs to.
Constraint Name:N/A
Constraint Description:N/A

cAudioType

Description:Foreign key to tblLVST_Audio_cAudiotype. Identifies the type of the audio.
Constraint Name:TypeMustExist
Constraint Description:Foreign Key to tblLVST_Audio_cAudioType.

cAudioFormat

Description:Foreign key to tblLVST_Audio_cAudioFormat. Identifies the encoding, bit rate, and sample size of the audio as a single string. For example, the value of SF_8PCM_16KHZ identifies an 8-bit, PCM (linear)-encoded audio file, sampled at 16 kHz.
Constraint Name:FormatMustExist
Constraint Description:Foreign key to tblLVST_Audio_cAudioFormat

AudioLengthInMs

Description:The length, in milliseconds, of the audio.
Constraint Name:N/A
Constraint Description:N/A

AudioLengthInBytes

Description:The length, in bytes, of the audio, before encoding using sqlite_encode_binary().
Constraint Name:N/A
Constraint Description:N/A

EncodedAudioLengthInBytes

Description:The length, in bytes, of the encoded audio, _stored in the database_. The original audio is usually using sqlite_encode_binary, and should be larger than the unencoded audio.
Constraint Name:N/A
Constraint Description:N/A

Table Constraints:

Constraint Name: N/A
Constraint Description: N/A
Columns related: N/A