Customfield Category Table Schema (customfield_category)


Description

core_customfield category table

customfield_category table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
customfield_field.categoryid custfiel_cat2_fk R
name VARCHAR 400
description LONGTEXT 2147483647 null
descriptionformat BIGINT 19 null
sortorder BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
component VARCHAR 100
area VARCHAR 100
itemid BIGINT 19 0
contextid BIGINT 19 null
context.id custcate_con2_fk R

Table contained -1 rows

customfield_category table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
custcate_comareitesor_ix Performance Asc/Asc/Asc/Asc component + area + itemid + sortorder
custcate_con_ix Performance Asc contextid

customfield_category table relationships