customfield_category

0 rows


Description

core_customfield category table

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
customfield_field.categoryid custfiel_cat2_fkR
customfield_shared.categoryid custshar_cat2_fkR
name VARCHAR 1333
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_fkR
shared BIT 1 √ 0

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

Relationships

Close relationships within degrees of separation