tblLVST_TranscriptScores

Table Description:

Aggregate scored results from the aligned transcripts and a particular scoring protocol run. Each score type sums all of the alignments of that type for a given transcription

Table structure:

Column Name Data Type Data Length Default Value See Also

ScoringProtocolID

INTEGER

N/A

N/A

N/A

cScoreType

INTEGER

N/A

N/A

tblLVST_TranscriptScores_cScoreType

TypeCount

INTEGER

N/A

0

N/A

TotalConf

FLOAT

N/A

0

N/A

TotalSquaredConf

FLOAT

N/A

0

N/A

MinConf

FLOAT

N/A

4294967295

N/A

MaxConf

FLOAT

N/A

0

N/A

InVocabulary

INTEGER

N/A

-1

N/A

OutOfVocabulary

INTEGER

N/A

-1

N/A

Primary Keys:

ScoreID

Foreign keys relationships:

Foreign key Reference table Reference key

ScoringProtocolID

tblLVST_ScoringProtocol

ScoringProtocolID

 
Foreign key Reference table Reference key

cScoreType

tblLVST_TranscriptScores_cScoreType

ConstantValue

 

Column Descriptions and Constraints:

ScoringProtocolID

Description:
The scoring protocol used to derive these scores.
Constraint Name:
N/A
Constraint Description:
N/A

cScoreType

Description:
Foreign key to tblLVST_TranscriptScores_cScoreType. The type of the token alignment score. This field maps to the ConstantValue defined by ConstantNames ('INSERTION', 'DELETION', 'SUBSTITUTION', 'OOV_INSERTION', 'NOISE_INSERTION', 'MATCH', 'OOV_MATCH', 'NOISE_MATCH') in tblLVST_TranscriptSCores_cScoreType.
Constraint Name:
'INSERTION', 'DELETION', 'SUBSTITUTION', 'OOV_INSERTION', 'NOISE_INSERTION', 'MATCH', 'OOV_MATCH', 'NOISE_MATCH'
Constraint Description:
Foreign key to tblLVST_TranscriptScores_cScoreType.

TypeCount

Description:
The total number of items with this alignment type (see ScoreType) in the transcript alignment.
Constraint Name:
N/A
Constraint Description:
N/A

TotalConf

Description:
The total summed confidence of each type of score in the alignment. Useful, among other things, for calculating average confidence.
Constraint Name:
N/A
Constraint Description:
N/A

TotalSquaredConf

Description:
The total squared confidence of each type of score in the alignment. Useful, among other things, for calculating variance and stdev.
Constraint Name:
N/A
Constraint Description:
N/A

MinConf

Description:
The lowest confidence score in the alignment. This is ULONG_MAX, as defined by MS Visual Studio 6.
Constraint Name:
N/A
Constraint Description:
N/A

MaxConf

Description:
The highest confidence score in the alignment.
Constraint Name:
N/A
Constraint Description:
N/A

InVocabulary

Description:
The count of in-vocabulary items in the alignment.
Constraint Name:
N/A
Constraint Description:
N/A

OutOfVocabulary

Description:
The count of out-of-vocabulary items in the alignment.
Constraint Name:
N/A
Constraint Description:
N/A
 

Table Constraints:

Constraint Name:N/A
Constraint Description:
N/A
Columns related:
N/A