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 keys relationships:

Foreign key Reference table Reference key

RawContent

tblLVST_GrammarContent

GContentID

 
Foreign key Reference table Reference key

ModifiedContent

tblLVST_GrammarContent

GContentID

 

Column Descriptions and Constraints:

GrammarDetailID

Description:
Autoincrementing primary key.
Constraint Name:
N/A
Constraint Description:
N/A

GrammarName

Description:
The label for this grammar.
Constraint Name:
N/A
Constraint Description:
N/A

GrammarURI

Description:
The URI for this grammar.
Constraint Name:
N/A
Constraint Description:
N/A

RawContent

Description:
Foreign key to tblLVST_GrammarContent. Identifies the raw grammar object in tblLVST_GrammarContent.
Constraint Name:
N/A
Constraint Description:
N/A

ModifiedContent

Description:
Foreign key to tblLVST_GrammarContent. Identifies the modified grammar object in tblLVST_GrammarContent.
Constraint Name:
N/A
Constraint Description:
N/A

TranslatedContent

Description:
Foreign key to tblLVST_GrammarContent. Identifies the translated grammar object in tblLVST_GrammarContent.
Constraint Name:
N/A
Constraint Description:
N/A

Table Constraints:

Constraint Name:Raw_Or_Modified
Constraint Description:
Either raw or modified must have a GContentID > 0; in the modified case, raw may not be present, because the grammar was built entirely by API.
Columns related:
RawContent, ModifiedContent

Constraint Name:
notexist
Constraint Description:
the combined name, uri, raw content, modified content, and translated content must be unique.
Columns related:
GrammarName, GrammarURI, RawContent, ModifiedContent, TranslatedContent