Customfield Field Table Schema (customfield_field)


Description

core_customfield field table

customfield_field table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
customfield_data.fieldid custdata_fie2_fk R
shortname VARCHAR 100
name VARCHAR 400
type VARCHAR 100
description LONGTEXT 2147483647 √ null
descriptionformat BIGINT 19 √ null
sortorder BIGINT 19 √ null
categoryid BIGINT 19 √ null
customfield_category.id custfiel_cat2_fk R
configdata LONGTEXT 2147483647 √ null
timecreated BIGINT 19 null
timemodified BIGINT 19 null

Table contained -1 rows

customfield_field table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
custfiel_cat_ix Performance Asc categoryid
custfiel_catsor_ix Performance Asc/Asc categoryid + sortorder

customfield_field table relationships

Close relationships within degrees of separation