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 10 null
fieldid bigint 10 0
data_fields.id datacont_fie2_fk R
recordid bigint 10 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