plg_asset_type


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
plg_asset_file.plg_asset_id FK_plg_asset_file_plg_asset R
plg_template_item.plg_asset_id FK_plg_template_item_plg_asset R
project_plg_item.plg_asset_id FK_project_plg_item_plg_asset R
name VARCHAR 256 √ null
description TEXT 65535 √ null
comment TEXT 65535 √ null
background VARCHAR 256 √ null
company_type_id INT 10 √ null
sys_company_types.type_id FK_plg_asset_type_company_type R
photo_id BIGINT 19 √ null
category_id BIGINT 19 √ null
asset_category.id FK_plg_asset_type_category R
is_archived BIT 1 √ b'0'
highlight BIT 1 √ b'0'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_plg_asset_type_category_idx Performance Asc category_id
FK_plg_asset_type_company_type_idx Performance Asc company_type_id

Relationships

Close relationships within degrees of separation