tblLVST_GrammarDetail

Table Description:

This table keeps track of a recognition grammar, including its raw and translated versions. Each entry is required to be unique, because although the name, URI, and raw content may be the same, the method to obtain the translated content need not be. Note that the name and URI are used in queries, so if the same raw grammar has a different name or URI, it won't be grouped with any other, even if they have the same content. It is possible to regroup it using a custom query, but the default system won't do it for you.

Table structure:

Column Name Data Type Data Length Default Value See Also
GrammarDetailID INTEGER N/A N/A N/A
GrammarName VARCHAR 900 N/A N/A
GrammarURI VARCHAR 900 N/A N/A
RawContent INTEGER N/A N/A tblLVST_GrammarContent
ModifiedContent INTEGER N/A -1 tblLVST_GrammarContent
TranslatedContent INTEGER N/A -1 tblLVST_GrammarContent

Primary Keys:

GrammarDetailID

Foreign Key Reference Table Reference Key
RawContent tblLVST_GrammarContent GContentID
ModifiedContent tblLVST_GrammarContent GContentID

Column Descriptions and Constraints:

Column Description Constraint Name Constraint Description
GrammarDetailID Autoincrementing primary key. N/A N/A
GrammarName The label for this grammar. N/A N/A
GrammarURI The URI for this grammar. N/A N/A
RawContent Foreign key to tblLVST_GrammarContent. Identifies the raw grammar object in tblLVST_GrammarContent. N/A N/A
ModifiedContent Foreign key to tblLVST_GrammarContent. Identifies the modified grammar object in tblLVST_GrammarContent. N/A N/A
TranslatedContent Foreign key to tblLVST_GrammarContent. Identifies the translated grammar object in tblLVST_GrammarContent. N/A N/A

Table Constraints:

Constraint Name Constraint Description Columns Related
notexist the combined name, uri, raw content, modified content, and translated content must be unique. GrammarName, GrammarURI, RawContent, ModifiedContent, TranslatedContent
© 2012 LumenVox LLC. All rights reserved.