project_plg_item


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
punch_list_item.plg_item_id FK_punchlist_item_giude_item R
name VARCHAR 256 √ null
plg_id BIGINT 19 null
project_plg.id FK_project_plg_item_project_plg R
status_id INT 10 null
plg_item_status.id FK_project_plg_item_plg_status R
asset_id BIGINT 19 √ null
asset_type.id FK_project_plg_item_asset R
plg_asset_id BIGINT 19 √ null
plg_asset_type.id FK_project_plg_item_plg_asset R
category_id BIGINT 19 √ null
project_plg_category.id FK_project_plg_item_category R
rank INT 10 0
background VARCHAR 256 √ null
description TEXT 65535 √ null
comment TEXT 65535 √ null
quantity INT 10 √ null
date_created DATETIME 19 √ null
date_completed DATETIME 19 √ null
completed_by INT 10 √ null
sys_users.user_id FK_project_plg_item_completed_by R
user_comment TEXT 65535 √ null
expected_quantity INT 10 √ null
highlight BIT 1 √ b'0'
capture_quantity BIT 1 √ 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_project_plg_item_asset_idx Performance Asc asset_id
FK_project_plg_item_category_idx Performance Asc category_id
FK_project_plg_item_completed_by Performance Asc completed_by
FK_project_plg_item_plg_asset_idx Performance Asc plg_asset_id
FK_project_plg_item_plg_status_idx Performance Asc status_id
FK_project_plg_item_project_plg_idx Performance Asc plg_id

Relationships

Close relationships within degrees of separation