bac_ins_f_au_develop_permit

30 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_au.develop_permit_id fk_bac_ins_f_au_on_develop_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_develop_permit_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_develop_permit_on_has_develop_permit R
project_description_comment varchar 2048 √ null
building_description_comment varchar 2048 √ null
subdivision_application_planned_lot_maximum int4 10 √ null
subdivision_application_building_complection_deferred_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfaudeveloppermit_on_subdivisionapplicationbuildingcomp R
camping_pitche_reserved_maximum int4 10 √ null
camping_guest_maximum int4 10 √ null
camping_light_leisure_housing_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_develop_permit_on_camping_light_leisure_housing R
camping_reserved_site_light_leisure_housing_maximum int4 10 √ null
camping_reserved_floor_area_light_leisure_housing int4 10 √ null
form_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_develop_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_develop_permit_on_site_plan_document R
site_plan_document_comment varchar 2048 √ null
develop_description_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_develop_permit_on_develop_description_document R
develop_description_document_comment varchar 2048 √ null
existing_development_description_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfaudeveloppermit_on_existingdevelopmentdescriptiondoc R
existing_development_description_document_comment varchar 2048 √ null
composition_development_description_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfaudeveloppermit_on_compositiondevelopmentdescription R
composition_development_description_document_comment varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_au_develop_permit Primary key Asc id
idx_bac_ins_f_au_develop_permit_composition_development_descrip Performance Asc composition_development_description_document_id
idx_bac_ins_f_au_develop_permit_develop_description_document Performance Asc develop_description_document_id
idx_bac_ins_f_au_develop_permit_existing_development_descriptio Performance Asc existing_development_description_document_id
idx_bac_ins_f_au_develop_permit_form_document Performance Asc form_document_id
idx_bac_ins_f_au_develop_permit_has_develop_permit Performance Asc has_develop_permit_id
idx_bac_ins_f_au_develop_permit_site_plan_document Performance Asc site_plan_document_id

Relationships

Close relationships within degrees of separation