parallel_sign_stream_section

0 rows


Description

This table enables a connection to be made between parallel words in two different manuscripts.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
parallel_sign_stream_section_id INT UNSIGNED 10 √ null
parallel_sign_stream_section_owner.parallel_sign_stream_section_id fk_par_sss_owner_to_par_sssR

Unique identifier
sign_stream_section_id INT UNSIGNED 10 null
sign_stream_section.sign_stream_section_id fk_par_sss_to_soign_stream_sectionR

Reference to sign_stream_section
parallel_group_id INT UNSIGNED 10 null
parallel_group.parallel_group_id fk_par_sss_to_parallel_groupR

Reference to parallel_group

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc parallel_sign_stream_section_id
fk_par_sss_to_group_idx Performance Asc parallel_group_id
fk_par_sss_to_word_idx Performance Asc sign_stream_section_id
unique_sign_stream_section_id_parallel_group_id_idx Must be unique Asc/Asc parallel_group_id + sign_stream_section_id

Relationships

Close relationships within degrees of separation