tblLVST_GrammarSet

Table Description:

The grammar tables, of which this is the top level, are necessarily complex, because of the varying ways of using different kinds of grammars. For LV_Concept grammars, the grammar set will only contain a single grammardetailid link, always as root, and with an active grammar identifier of 0. However, SRGS allows multiple, active, root grammars which compete during the decode. In this case, it becomes necessary to track which grammars are root, and which are not, to reconstruct the recognition grammars. LumenVox always stores the subordinate grammar used (external ones referenced by URI from the root or other external grammars); for other systems, the grammars stored may only be th top level grammar.

Table structure:

Column Name Data Type Data Length Default Value See Also

RequestID

INTEGER

N/A

N/A

tblLVST_Requests

ActiveGrammarSet

INTEGER

N/A

0

tblLVST_GrammarDetail

GrammarDetailID

INTEGER

N/A

0

tblLVST_GrammarDetail

cIsRoot

INTEGER

N/A

0

tblLVST_GrammarSet_cIsRoot

Primary Keys:

GrammarSetID

Foreign keys relationships:

Foreign key Reference table Reference key

RequestID

tblLVST_Requests

RequestID

 
Foreign key Reference table Reference key

GrammarDetailID

tblLVST_GrammarDetail

GrammarDetailID

 
Foreign key Reference table Reference key

cIsRoot

tblLVST_GrammarSet_cIsRoot

ConstantValue

 

Column Descriptions and Constraints:

RequestID

Description:
Identifies the request this grammar set belongs to.
Constraint Name:
N/A
Constraint Description:
N/A

ActiveGrammarSet

Description:
Identifies one (there can be more) active grammar set for the requested decode.
Constraint Name:
N/A
Constraint Description:
N/A

GrammarDetailID

Description:
Identifies the detailed grammar description, including raw and translated forms, etc.
Constraint Name:
N/A
Constraint Description:
N/A

cIsRoot

Description:
Identifies the grammar detail as the root grammar for this request and active set. Uses 'TRUE' and 'FALSE' constant values to indicate yes or no.
Constraint Name:
N/A
Constraint Description:
N/A
 

Table Constraints:

Constraint Name:OneRoot
Constraint Description:
There can be only one root for a (request, active grammar set). Every other grammar in that pair must be a subordinate grammar.
Columns related:
RequestID, ActiveGrammarSet, IsRoot