position_in_stream

1719776 rows


Description

This table provides ordering data for the transcriptions. It provides a DAG linking sign_interpretations to each other.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
position_in_stream_id INT UNSIGNED 10 √ null
position_in_stream_owner.position_in_stream_id fk_position_in_stream_owner_to_position_in_streamR
position_in_stream_to_section_rel.position_in_stream_id fk_position_in_stream_to_section_rel_to_position_in_streamR
sign_interpretation_id INT UNSIGNED 10 null
sign_interpretation.sign_interpretation_id fk_position_in_stream_to_sign_interpretationR
next_sign_interpretation_id INT UNSIGNED 10 √ NULL
sign_interpretation.sign_interpretation_id fk_position_in_stream_to_next_sign_interpretationR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc position_in_stream_id
fk_position_in_stream_to_next_sign_interpretation Performance Asc next_sign_interpretation_id
fk_position_in_stream_to_sign_interpretation Performance Asc sign_interpretation_id

Relationships

Close relationships within degrees of separation