text_fragment_data

11172 rows


Description

This table defines the properties of a unified grouping of text containing one or more lines.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
text_fragment_data_id INT UNSIGNED 10 √ null
text_fragment_data_owner.text_fragment_data_id fk_text_fragment_data_owner_to_text_fragment_dataC
text_fragment_id INT UNSIGNED 10 null
text_fragment.text_fragment_id fk_text_fragment_data_to_text_fragmentC
name VARCHAR 255 √ 'NULL'

Name designation for this fragment of text (usually col. x or frg. x).

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc text_fragment_data_id
fk_text_fragment_data_to_text_fragment_idx Performance Asc text_fragment_id
unique_text_fragment_id_text_fragment_name Must be unique Asc/Asc text_fragment_id + name

Relationships

Close relationships within degrees of separation