asset_category


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
asset_type.category_id FK7EF1B329A980DACA R
plg_asset_type.category_id FK_plg_asset_type_category R
program_asset_categories.asset_category_id FK_d6eh30pt2fd7ddmqpkjjmkhgw R
punch_list_item.asset_category_id FK_nq8hwkavi57ea0gnyhlsg7fvk R
version INT 10 √ 0
name VARCHAR 50 null
rank INT 10 null
not_included_update_action INT 10 √ null
punchlist_eligible BIT 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
name Must be unique Asc name

Relationships

Close relationships within degrees of separation