bac_ins_f_au_demolition_permit

30 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_au.demolition_permit_id fk_bac_ins_f_au_on_demolition_permit R
deleted_by varchar 255 √ null
deleted_date timestamp 29,6 √ null
version int4 10 null
created_by varchar 255 √ null
created_date timestamp 29,6 √ null
last_modified_by varchar 255 √ null
last_modified_date timestamp 29,6 √ null
has_demolition_permit_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_demolition_permit_on_has_demolition_permit R
form_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_demolition_permit_on_form_document R
form_document_comment varchar 2048 √ null
site_plan_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_demolition_permit_on_site_plan_document R
site_plan_document_comment varchar 2048 √ null
floor_plan_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_demolition_permit_on_floor_plan_document R
floor_plan_document_comment varchar 2048 √ null
building_to_demolish_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfaudemolitionpermit_on_buildingtodemolishdocument R
building_to_demolish_document_comment varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_au_demolition_permit Primary key Asc id
idx_bac_ins_f_au_demolition_permit_building_to_demolish_documen Performance Asc building_to_demolish_document_id
idx_bac_ins_f_au_demolition_permit_floor_plan_document Performance Asc floor_plan_document_id
idx_bac_ins_f_au_demolition_permit_form_document Performance Asc form_document_id
idx_bac_ins_f_au_demolition_permit_has_demolition_permit Performance Asc has_demolition_permit_id
idx_bac_ins_f_au_demolition_permit_site_plan_document Performance Asc site_plan_document_id

Relationships

Close relationships within degrees of separation