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

Close relationships within degrees of separation