tblLVST_AudioData

Table Description:

Stores the actual binary audio data for the specified recording. You must use sqlite_encode_binary and sqlite_decode_binary to load the audio into the database, and to use the audio once you have retrieved it from the database.

Table structure:

Column Name Data Type Data Length Default Value See Also
AudioID INTEGER N/A N/A tblLVST_Audio
AudioData TEXT N/A N/A N/A

Primary Keys:

N/A

Foreign Key Reference Table Reference Key
AudioID tblLVST_Audio AudioID

Column Descriptions and Constraints:

Column Description Constraint Name Constraint Description
AudioID Foreign key to tblLVST_Audio. N/A N/A
AudioData The encoded audio data. The data is encoded using sqlite_encode_binary; to use it, you *must* call sqlite_decode_binary to translate it back to the original form. N/A N/A

Table Constraints:

Constraint Name Constraint Description Columns Related
N/A N/A N/A
© 2012 LumenVox LLC. All rights reserved.