bac_ins_f_au_urbanism_certificate

30 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_au.urbanism_certificate_id fk_bac_ins_f_au_on_urbanism_certificate 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
land_in_sanitized_zone_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_urbanism_certificate_on_land_in_sanitized_zone R
land_served_by_sewer_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_urbanism_certificate_on_land_served_by_sewer R
sewer_type_comment varchar 2048 √ null
land_partially_served_by_sewer_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfauurbanismcertificate_on_landpartiallyservedbysewer R
partial_sewer_type_comment varchar 2048 √ null
sewer_system_sized_to_new_effluent_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfauurbanismcertificate_on_sewersystemsizedtoneweffluen R
land_served_after_reinforcement_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfauurbanismcertificate_on_landservedafterreinforcement R
land_served_after_reinforcement_under_track varchar 255 √ null
land_served_after_reinforcement_over_distance_m int4 10 √ null
land_served_after_reinforcement_schedule_date date 13 √ null
land_served_after_extension_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfauurbanismcertificate_on_landservedafterextension R
land_served_after_extension_under_track varchar 255 √ null
land_served_after_extension_over_distance_m int4 10 √ null
land_served_after_extension_schedule_date date 13 √ null
land_connectable_as_proposed_financial_assistance_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfauurbanismcertificate_on_landconnectableasproposedfin R
land_connectable_as_pvr_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_urbanism_certificate_on_land_connectable_as_pvr R
land_connectable_as_zac_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_urbanism_certificate_on_land_connectable_as_zac R
land_connected_to_subdivision_network_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfauurbanismcertificate_on_landconnectedtosubdivisionne R
subdivision_network varchar 255 √ null
subdivision varchar 255 √ null
building_permit_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_urbanism_certificate_on_building_permit R
building_permit_number varchar 255 √ null
pipe_right_of_way_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_urbanism_certificate_on_pipe_right_of_way R
pipe_right_of_way_via_parcels varchar 255 √ null
pipe_right_of_way_distance_m int4 10 √ null
authorization_connect_to_existing_private_network_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfauurbanismcertificate_on_authorizationconnecttoexisti R
existing_private_network_connection_distance_m int4 10 √ null
existing_connection_to_wastewater_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfauurbanismcertificate_on_existingconnectiontowastewat R
authorization_order_connection_to_wastewater_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfauurbanismcertificate_on_authorizationorderconnection R
order_number varchar 255 √ null
incomplete_administrative_file_for_existing_connection_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfauurbanismcertificate_on_incompleteadministrativefile R
requirements_comment varchar 2048 √ null
additional_documents_comment varchar 2048 √ null
unfavorable_opinion_reasons_comment varchar 2048 √ null
planning_certificate_form_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfauurbanismcertificate_on_planningcertificateformdocum R
planning_certificate_form_document_comment varchar 2048 √ null
location_plan_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_urbanism_certificate_on_location_plan_document R
location_plan_document_comment varchar 2048 √ null
brief_descriptive_note_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfauurbanismcertificate_on_briefdescriptivenotedocument R
brief_descriptive_note_document_comment varchar 2048 √ null
site_plan_document_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_urbanism_certificate_on_site_plan_document R
site_plan_document_comment varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_au_urbanism_certificate Primary key Asc id
idx_bac_ins_f_au_urbanism_certificate_authorization_connect_to_ Performance Asc authorization_connect_to_existing_private_network_id
idx_bac_ins_f_au_urbanism_certificate_authorization_order_conne Performance Asc authorization_order_connection_to_wastewater_id
idx_bac_ins_f_au_urbanism_certificate_brief_descriptive_note_do Performance Asc brief_descriptive_note_document_id
idx_bac_ins_f_au_urbanism_certificate_building_permit Performance Asc building_permit_id
idx_bac_ins_f_au_urbanism_certificate_existing_connection_to_wa Performance Asc existing_connection_to_wastewater_id
idx_bac_ins_f_au_urbanism_certificate_incomplete_administrative Performance Asc incomplete_administrative_file_for_existing_connection_id
idx_bac_ins_f_au_urbanism_certificate_land_connectable_as_propo Performance Asc land_connectable_as_proposed_financial_assistance_id
idx_bac_ins_f_au_urbanism_certificate_land_connectable_as_pvr Performance Asc land_connectable_as_pvr_id
idx_bac_ins_f_au_urbanism_certificate_land_connectable_as_zac Performance Asc land_connectable_as_zac_id
idx_bac_ins_f_au_urbanism_certificate_land_connected_to_subdivi Performance Asc land_connected_to_subdivision_network_id
idx_bac_ins_f_au_urbanism_certificate_land_in_sanitized_zone Performance Asc land_in_sanitized_zone_id
idx_bac_ins_f_au_urbanism_certificate_land_partially_served_by_ Performance Asc land_partially_served_by_sewer_id
idx_bac_ins_f_au_urbanism_certificate_land_served_after_extensi Performance Asc land_served_after_extension_id
idx_bac_ins_f_au_urbanism_certificate_land_served_after_reinfor Performance Asc land_served_after_reinforcement_id
idx_bac_ins_f_au_urbanism_certificate_land_served_by_sewer Performance Asc land_served_by_sewer_id
idx_bac_ins_f_au_urbanism_certificate_location_plan_document Performance Asc location_plan_document_id
idx_bac_ins_f_au_urbanism_certificate_pipe_right_of_way Performance Asc pipe_right_of_way_id
idx_bac_ins_f_au_urbanism_certificate_planning_certificate_form Performance Asc planning_certificate_form_document_id
idx_bac_ins_f_au_urbanism_certificate_sewer_system_sized_to_new Performance Asc sewer_system_sized_to_new_effluent_id
idx_bac_ins_f_au_urbanism_certificate_site_plan_document Performance Asc site_plan_document_id

Relationships

Close relationships within degrees of separation