Customfield Data Table Schema (customfield_data)


Description

core_customfield data table

customfield_data table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
fieldid BIGINT 19 null
customfield_field.id custdata_fie2_fk R
instanceid BIGINT 19 null
intvalue BIGINT 19 √ null
decvalue DECIMAL 10,5 √ null
shortcharvalue VARCHAR 255 √ null
charvalue VARCHAR 1333 √ null
value LONGTEXT 2147483647 null
valueformat BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
contextid BIGINT 19 √ null
context.id custdata_con2_fk R

Table contained -1 rows

customfield_data table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
custdata_con_ix Performance Asc contextid
custdata_fie_ix Performance Asc fieldid
custdata_fiedec_ix Performance Asc/Asc fieldid + decvalue
custdata_fieint_ix Performance Asc/Asc fieldid + intvalue
custdata_fiesho_ix Performance Asc/Asc fieldid + shortcharvalue
custdata_insfie_uix Must be unique Asc/Asc instanceid + fieldid

customfield_data table relationships

Close relationships within degrees of separation