2557225 rows


This table links sign_interpretations to the attributes that further describe the sign’s interpretation.


Column Type Size Nulls Auto Default Children Parents Comments
sign_interpretation_attribute_id INT UNSIGNED 10 null
sign_interpretation_attribute_owner.sign_interpretation_attribute_id fk_sign_interpretation_attr_owner_to_scaR
sign_interpretation_id INT UNSIGNED 10 null
sign_interpretation.sign_interpretation_id fk_sign_interpretation_attr_to_sign_interpretationR

Id of the sign interpretation being descibed.

attribute_value_id INT UNSIGNED 10 null
attribute_value.attribute_value_id fk_sign_interpretation_attr_to_attr_valueR

Id of the attribute to apply to this sign interpretation.

sequence TINYINT 3 NULL

Absolute ordering of this record. This is used to define the order of all records for the same sign_char_id.

numeric_value FLOAT 12 NULL

Contains the width of a character (normally 1), space (dto.), or vacat (normally > 1) or the level of probability.


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc sign_interpretation_attribute_id
fk_sign_interpretation_attr_to_attr_value_idx Performance Asc attribute_value_id
fk_sign_interpretation_attr_to_sign_interpretation_idx Performance Asc sign_interpretation_id
unique_sign_interpretation_id_attribute_value_id_sequence Must be unique Asc/Asc/Asc attribute_value_id + sequence + sign_interpretation_id