plg_template_item


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
name VARCHAR 256 √ null
template_id BIGINT 19 null
plg_template.id FK_plg_template_item_plg_template R
asset_id BIGINT 19 √ null
asset_type.id FK_plg_template_item_asset R
plg_asset_id BIGINT 19 √ null
plg_asset_type.id FK_plg_template_item_plg_asset R
category_id BIGINT 19 √ null
plg_template_category.id FK_plg_template_item_category R
rank INT 10 0
background VARCHAR 256 √ null
description TEXT 65535 √ null
comment TEXT 65535 √ null
highlight BIT 1 √ null
capture_quantity BIT 1 √ 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_plg_template_item_asset_idx Performance Asc asset_id
FK_plg_template_item_category_idx Performance Asc category_id
FK_plg_template_item_plg_asset_idx Performance Asc plg_asset_id
FK_plg_template_item_plg_template_idx Performance Asc template_id

Relationships

Close relationships within degrees of separation