Data Content Table Schema (data_content)


Description

the content introduced in each record/fields

data_content table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
fieldid BIGINT 19 0
data_fields.id datacont_fie2_fk R
recordid BIGINT 19 0
data_records.id datacont_rec2_fk R
content LONGTEXT 2147483647 √ null
content1 LONGTEXT 2147483647 √ null
content2 LONGTEXT 2147483647 √ null
content3 LONGTEXT 2147483647 √ null
content4 LONGTEXT 2147483647 √ null

Table contained -1 rows

data_content table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
datacont_fie_ix Performance Asc fieldid
datacont_rec_ix Performance Asc recordid

data_content table relationships

Close relationships within degrees of separation