punch_list_item


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
punch_list_item_history.item_id FK_8d9o4xvhashai2g3tad53mwus R
punch_list_item_note.item_id FK_sqlolbtd5xp1y0g8h6vo8deq2 R
punch_list_item_recipients_company_email.item_id FKEA9683D149913482 R
punch_list_item_recipients_company_user.item_id FKE69058F649913482 R
punch_list_item_recipients_role_user.item_id FK35F87BEB49913482 R
version BIGINT 19 null
category_id BIGINT 19 null
punch_list_category.id FKDB8A30433E9054A2 R
complete_date DATETIME 19 √ null
description VARCHAR 2000 null
last_update DATETIME 19 √ null
number INT 10 null
stores_non_branded.number Implied Constraint R
project_id INT 10 null
project.id FKDB8A3043FE2B983 R
scheduled_date DATETIME 19 √ null
sla_exception INT 10 √ null
punch_list_sla_exception_type.id FKDB8A3043BAE22181 R
sub_category_id BIGINT 19 √ null
punch_list_sub_category.id FKDB8A30433EC39B33 R
vendor_id INT 10 null
sys_companies.company_id FKDB8A30438A57A86 R
create_date DATETIME 19 √ null
asset_type_id BIGINT 19 √ null
asset_type.id FKDB8A3043198EEAFB R
reason_code_id BIGINT 19 √ null
punch_list_reason.id FKDB8A304399B55D9E R
marked_complete_by_id INT 10 √ null
sys_users.user_id FK_3xihx7o0b8djj2qoc12or1uy2 R
marked_complete_on DATETIME 19 √ null
dept_name VARCHAR 255 √ null
asset_category_id BIGINT 19 √ null
asset_category.id FK_nq8hwkavi57ea0gnyhlsg7fvk R
plg_item_id BIGINT 19 √ null
project_plg_item.id FK_punchlist_item_giude_item R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
asset_type_id Performance Asc asset_type_id
category_id Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc category_id + project_id + sub_category_id + vendor_id + asset_type_id + reason_code_id + marked_complete_by_id
category_id_2 Performance Asc/Asc/Asc/Asc category_id + project_id + vendor_id + asset_type_id
FK_3xihx7o0b8djj2qoc12or1uy2 Performance Asc marked_complete_by_id
FK_nq8hwkavi57ea0gnyhlsg7fvk Performance Asc asset_category_id
FK_punchlist_item_giude_item_idx Performance Asc plg_item_id
FKDB8A3043198EEAFB Performance Asc asset_type_id
FKDB8A30433E9054A2 Performance Asc category_id
FKDB8A30433EC39B33 Performance Asc sub_category_id
FKDB8A30438A57A86 Performance Asc vendor_id
FKDB8A304399B55D9E Performance Asc reason_code_id
FKDB8A3043BAE22181 Performance Asc sla_exception
FKDB8A3043FE2B983 Performance Asc project_id
project_id Must be unique Asc/Asc project_id + number
unique_number Must be unique Asc/Asc project_id + number

Relationships

Close relationships within degrees of separation