customfield_field

0 rows


Description

core_customfield field table

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
customfield_data.fieldid custdata_fie2_fkR
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_fkR
configdata LONGTEXT 2147483647 √ null
timecreated BIGINT 19 null
timemodified BIGINT 19 null

Indexes

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

Relationships

Close relationships within degrees of separation