position_in_stream_to_word_rel

1238159 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_word_rel_to_position_in_streamR
word_id INT UNSIGNED 10 null
word.word_id fk_position_in_stream_to_word_rel_to_word_idR
position_in_word TINYINT UNSIGNED 3 √ NULL

Indexes

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

Relationships

Close relationships within degrees of separation