bac_ins_f_au_building_permit

30 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_au.building_permit_id fk_bac_ins_f_au_on_building_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_building_permit_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_building_permit_on_has_building_permit R
architect_using_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_building_permit_on_architect_using R
architect_id uuid 2147483647 √ null
thirdp_legal_person.id fk_bac_ins_f_au_building_permit_on_architect R
new_building_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_building_permit_on_new_building R
building_on_existant_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_building_permit_on_building_on_existant R
building_description varchar 2048 √ null
swimming_pool_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_building_permit_on_swimming_pool R
usage_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_building_permit_on_usage R
form_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_building_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_building_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_building_permit_on_floor_plan_document R
floor_plan_document_comment varchar 2048 √ null
sectional_drawing_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_building_permit_on_sectional_drawing_document R
sectional_drawing_document_comment varchar 2048 √ null
building_notice_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_building_permit_on_building_notice_document R
building_notice_document_comment varchar 2048 √ null
facade_roof_plan_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_building_permit_on_facade_roof_plan_document R
facade_roof_plan_document_comment varchar 2048 √ null
building_project_integration_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfaubuildingpermit_on_buildingprojectintegrationdocumen R
building_project_integration_document_comment varchar 2048 √ null
site_photo_in_environment_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfaubuildingpermit_on_sitephotoinenvironmentdocument R
site_photo_in_environment_document_comment varchar 2048 √ null
site_photo_in_landscape_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfaubuildingpermit_on_sitephotoinlandscapedocument R
site_photo_in_landscape_document_comment varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_au_building_permit Primary key Asc id
idx_bac_ins_f_au_building_permit_architect_using Performance Asc architect_using_id
idx_bac_ins_f_au_building_permit_building_notice_document Performance Asc building_notice_document_id
idx_bac_ins_f_au_building_permit_building_on_existant Performance Asc building_on_existant_id
idx_bac_ins_f_au_building_permit_building_project_integration_d Performance Asc building_project_integration_document_id
idx_bac_ins_f_au_building_permit_facade_roof_plan_document Performance Asc facade_roof_plan_document_id
idx_bac_ins_f_au_building_permit_floor_plan_document Performance Asc floor_plan_document_id
idx_bac_ins_f_au_building_permit_form_document Performance Asc form_document_id
idx_bac_ins_f_au_building_permit_has_building_permit Performance Asc has_building_permit_id
idx_bac_ins_f_au_building_permit_new_building Performance Asc new_building_id
idx_bac_ins_f_au_building_permit_sectional_drawing_document Performance Asc sectional_drawing_document_id
idx_bac_ins_f_au_building_permit_site_photo_in_environment_docu Performance Asc site_photo_in_environment_document_id
idx_bac_ins_f_au_building_permit_site_photo_in_landscape_docume Performance Asc site_photo_in_landscape_document_id
idx_bac_ins_f_au_building_permit_site_plan_document Performance Asc site_plan_document_id
idx_bac_ins_f_au_building_permit_swimming_pool Performance Asc swimming_pool_id
idx_bac_ins_f_au_building_permit_usage Performance Asc usage_id

Relationships

Close relationships within degrees of separation