asset_type


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
asset.type_id FK_asset_asset_type R
asset_action.asset_type_id FK67B16265198EEAFB R
asset_log.type_id FK4E6AC57545D4494A R
asset_template_type.type_id FKF3F210D045D4494A R
asset_type_file.asset_type_id FK_17vlf0i8pm8wrfyvhuvtxge73 R
asset_warranty.asset_type_id FKC17E956B198EEAFB R
plg_template_item.asset_id FK_plg_template_item_asset R
project_field.asset_type_id FKC752D854198EEAFB R
project_plg_item.asset_id FK_project_plg_item_asset R
punch_list_item.asset_type_id FKDB8A3043198EEAFB R
warranty_log.type_id FK_31snucjrlpnp5ajdtk97vrj88 R
version INT 10 √ 0
category_id BIGINT 19 null
asset_category.id FK7EF1B329A980DACA R
code VARCHAR 25 null
description VARCHAR 100 null
dimensions VARCHAR 100 √ null
lead_time VARCHAR 100 √ null
merchandising_id VARCHAR 60 √ null
notes LONGTEXT 2147483647 √ null
part_number VARCHAR 100 √ null
vendor LONGTEXT 2147483647 √ null
vendor_id INT 10 √ null
sys_companies.company_id FK7EF1B3298A57A86 R
warranty BIT 1 b'0'
warranty_manager_id BIGINT 19 √ null
asset_warranty_manager.id FK7EF1B329EDE37D51 R
plg_description TEXT 65535 √ null
plg_comment TEXT 65535 √ null
company_type_id INT 10 √ null
sys_company_types.type_id FK_asset_type_company_type R
highlight BIT 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
code Must be unique Asc code
FK7EF1B3298A57A86 Performance Asc vendor_id
FK7EF1B329A980DACA Performance Asc category_id
FK7EF1B329EDE37D51 Performance Asc warranty_manager_id
FK_asset_type_company_type Performance Asc company_type_id
merchandising_id Must be unique Asc merchandising_id

Relationships

Close relationships within degrees of separation