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