position_in_text_fragment_stream_owner

10450 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
position_in_text_fragment_stream_id INT UNSIGNED 10 null
position_in_text_fragment_stream.position_in_text_fragment_stream_id fk_pitfs_owner_pitfsR
edition_id INT UNSIGNED 10 null
edition.edition_id fk_pitfs_owner_to_editionR
edition_editor_id INT UNSIGNED 10 null
edition_editor.edition_editor_id fk_pitfs_owner_to_editorR
is_main BIT 3 0

If true, the next item will be
first in the list of next items. There should
only one next item marked this way
for each item of this owner.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc position_in_text_fragment_stream_id + edition_id
fk_pitfs_owner_to_edition Performance Asc edition_id
fk_pitfs_owner_to_editor Performance Asc edition_editor_id

Relationships

Close relationships within degrees of separation