sign_interpretation

1189027 rows


Description

This table describes the interpretation of signs in an edition. Currently this includes both characters, spaces, and formatting marks, it could perhaps also include other elements that one might want to define as a sign.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
sign_interpretation_id INT UNSIGNED 10 √ null
position_in_stream.next_sign_interpretation_id fk_position_in_stream_to_next_sign_interpretationR
position_in_stream.sign_interpretation_id fk_position_in_stream_to_sign_interpretationR
sign_interpretation_attribute.sign_interpretation_id fk_sign_interpretation_attr_to_sign_interpretationR
sign_interpretation_commentary.sign_interpretation_id fk_sign_interpretation_commentary_to_sign_charR
sign_interpretation_roi.sign_interpretation_id fk_sign_sign_roi_to_sign_interpretationR
sign_id INT UNSIGNED 10 null
sign.sign_id fk_sign_interpretation_to_signR

Id of the sign being described.
is_variant TINYINT UNSIGNED 3 0

Boolean set to true when current entry is a variant interpretation of a sign.
character CHAR 1 √ NULL

This may be left null for signs that are not interpreted as characters (e.g., control signs like line start/line end or material features of any sort), otherwise it is a single letter.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc sign_interpretation_id
fk_sign_interpretation_to_sign_idx Performance Asc sign_id
unique_sign_id_is_variant_sign Must be unique Asc/Asc/Asc is_variant + character + sign_id

Relationships

Close relationships within degrees of separation