position_in_stream_to_section_rel

1238253 rows


Description

This table links sign_interpretations to the words they are part of. This creates a bridge from the SQE data to the words stored in the QWB database.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
position_in_stream_id INT UNSIGNED 10 null
position_in_stream.position_in_stream_id fk_position_in_stream_to_section_rel_to_position_in_streamR
sign_stream_section_id INT UNSIGNED 10 null
sign_stream_section.sign_stream_section_id fk_position_in_stream_to_section_rel_to_word_idR

Reference to sign_stream_section

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc position_in_stream_id + sign_stream_section_id
fk_position_in_stream_to_section_rel_to_word_id Performance Asc sign_stream_section_id

Relationships

Close relationships within degrees of separation