This table represents the actual semantic interpretation from a given result. The table is *NOT* designed to explicitly represent each SI result; instead, it expects the logging system to name the object involved in a way that allows a programmatic approach to rebuilding the object, somehow. For ECMAScript, for example, the following object might be represented in the system as follows: myobject.primaryphonenumber = '9876541234' myobject.zipcode = '95070' myobject.altphonenumberasarray[0] = '12237708' myobject.altphonenumberasarray[1] = '182743210' myobject.altphonenumberasarray[2] = '182182' and might resolve to (in the database): Object name ObjectType ObjectValue 'myobject', 'object' NULL 'myobject.primaryphonenumber', 'string', '9876541234' 'myobject.zipcode', 'string', '95070' 'myobject.altphonenumberasarray', 'array', NULL 'myobject.altphonenumberasarray[0]', 'string', '12237708' 'myobject.altphonenumberasarray[1]', 'string', '182743210' 'myobject.altphonenumberasarray[2]', 'string', '182182' This imposes a requirement on the code that *reads* this data; it *must* be able to reconstruct the object based on the the name and values involved. tblLVST_SemanticResults will indicate the particular SI protocol involved (i.e. whether the result is ECMAScript, GSL, LV_Concepts, or something else).
| Column Name | Data Type | Data Length | Default Value | See Also |
| SOID | INTEGER | N/A | N/A | N/A |
| SemanticResultID | INTEGER | N/A | N/A | N/A |
| stObjectName | INTEGER | N/A | N/A | tblLVST_StringTable |
| cObjectType | INTEGER | N/A | N/A | N/A |
| stObjectValue | INTEGER | N/A | N/A | N/A |
| orderFound | INTEGER | N/A | N/A | N/A |
| confidence | FLOAT | N/A | N/A | N/A |
SOID
| Foreign key | Reference table | Reference key |
| SemanticResultID | tblLVST_SemanticResults | SemanticResultID |
| Foreign key | Reference table | Reference key |
| stObjectName | tblLVST_StringTable | StringID |
| Foreign key | Reference table | Reference key |
| cObjectType | tblLVST_SemanticObjects_cObjectType | ConstantValue |
| Foreign key | Reference table | Reference key |
| stObjectValue | tblLVST_StringTable | StringTable |
SOID
Description:Autoincrementing primary key.
Constraint Name:N/A
Constraint Description:N/A
SemanticResultID
Description:Identifies the semantic result this entry belongs to. Foreign key to tblLVST_SemanticResults.
Constraint Name:N/A
Constraint Description:N/A
stObjectName
Description:Foreign key to tblLVST_StringTable. Identifies the 'name' of the object. See the table description for its use.
Constraint Name:N/A
Constraint Description:N/A
cObjectType
Description:Foreign key to tblLVST_SemanticObjects_cObjectType. Identifies the type of the object. See the table description for its use.
Constraint Name:'STRING', 'NUMBER', 'OBJECT', 'ARRAY', 'BOOL'
Constraint Description:Foreign key to tblLVST_SemanticObjects_cObjectType
stObjectValue
Description:Foreign key to tblLVST_StringTable. Identifies the value of the object. The value *must* be representable as a string. It if isn't, then you probably need to reduce the object to its primitives.
Constraint Name:N/A
Constraint Description:N/A
orderFound
Description:The order index of the semantic object was found in the semantic result.
Constraint Name:N/A
Constraint Description:N/A
confidence
Description:The confidence of the semantic Object. It has no confidence if the confidence score is -1
Constraint Name:N/A
Constraint Description:N/A
Constraint Name:N/A
Constraint Description:N/A
Columns related:N/A