text_fragment_to_line

53405 rows


Description

This table links lines of an edition to a specific text fragment.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
text_fragment_to_line_id INT UNSIGNED 10 null
text_fragment_to_line_owner.text_fragment_to_line_id fk_text_fragment_to_line_owner_to_text_fragment_to_lineR
text_fragment_id INT UNSIGNED 10 null
text_fragment.text_fragment_id fk_text_fragment_to_line_to_text_fragmentR
line_id INT UNSIGNED 10 null
line.line_id fk_text_fragment_to_line_to_lineR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc text_fragment_to_line_id
fk_text_fragment_to_line_to_line_idx Performance Asc line_id
text_fragment_line_idx Must be unique Asc/Asc text_fragment_id + line_id

Relationships