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
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_fkR

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