bac_inspection_form_simple_list

180 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_au.connection_possible_id fk_bac_ins_f_au_on_connection_possible R
bac_ins_f_au.decision_nature_id fk_bac_ins_f_au_on_decision_nature R
bac_ins_f_au.destination_id fk_bac_ins_f_au_on_destination R
bac_ins_f_au.existing_urbanism_certificate_id fk_bac_ins_f_au_on_existing_urbanism_certificate R
bac_ins_f_au.has_modification_permit_id fk_bac_ins_f_au_on_has_modification_permit_reason R
bac_ins_f_au.has_other_permit_id fk_bac_ins_f_au_on_has_other_permit_reason R
bac_ins_f_au.has_subdivision_permit_id fk_bac_ins_f_au_on_has_subdivision_permit R
bac_ins_f_au.has_transfer_permit_id fk_bac_ins_f_au_on_has_transfer_permit_reason R
bac_ins_f_au.land_in_concerted_development_zone_id fk_bac_ins_f_au_on_land_in_concerted_development_zone R
bac_ins_f_au.land_in_subdivision_id fk_bac_ins_f_au_on_land_in_subdivision R
bac_ins_f_au.requestor_communication_id fk_bac_ins_f_au_on_requestor_communication R
bac_ins_f_au.survey_origin_id fk_bac_ins_f_au_on_survey_origin R
bac_ins_f_au.urbanism_authorization_type_id fk_bac_ins_f_au_on_urbanism_authorization_type R
bac_ins_f_au_building_permit.architect_using_id fk_bac_ins_f_au_building_permit_on_architect_using R
bac_ins_f_au_building_permit.building_notice_document_id fk_bac_ins_f_au_building_permit_on_building_notice_document R
bac_ins_f_au_building_permit.building_on_existant_id fk_bac_ins_f_au_building_permit_on_building_on_existant R
bac_ins_f_au_building_permit.building_project_integration_document_id fk_bacinsfaubuildingpermit_on_buildingprojectintegrationdocumen R
bac_ins_f_au_building_permit.facade_roof_plan_document_id fk_bac_ins_f_au_building_permit_on_facade_roof_plan_document R
bac_ins_f_au_building_permit.floor_plan_document_id fk_bac_ins_f_au_building_permit_on_floor_plan_document R
bac_ins_f_au_building_permit.form_document_id fk_bac_ins_f_au_building_permit_on_form_document R
bac_ins_f_au_building_permit.has_building_permit_id fk_bac_ins_f_au_building_permit_on_has_building_permit R
bac_ins_f_au_building_permit.new_building_id fk_bac_ins_f_au_building_permit_on_new_building R
bac_ins_f_au_building_permit.sectional_drawing_document_id fk_bac_ins_f_au_building_permit_on_sectional_drawing_document R
bac_ins_f_au_building_permit.site_photo_in_environment_document_id fk_bacinsfaubuildingpermit_on_sitephotoinenvironmentdocument R
bac_ins_f_au_building_permit.site_photo_in_landscape_document_id fk_bacinsfaubuildingpermit_on_sitephotoinlandscapedocument R
bac_ins_f_au_building_permit.site_plan_document_id fk_bac_ins_f_au_building_permit_on_site_plan_document R
bac_ins_f_au_building_permit.swimming_pool_id fk_bac_ins_f_au_building_permit_on_swimming_pool R
bac_ins_f_au_building_permit.usage_id fk_bac_ins_f_au_building_permit_on_usage R
bac_ins_f_au_decision.compliance_rainwater_decision_id fk_bac_ins_f_au_decision_on_compliance_rainwater_decision R
bac_ins_f_au_decision.compliance_wastewater_decision_id fk_bac_ins_f_au_decision_on_compliance_wastewater_decision R
bac_ins_f_au_demolition_permit.building_to_demolish_document_id fk_bacinsfaudemolitionpermit_on_buildingtodemolishdocument R
bac_ins_f_au_demolition_permit.floor_plan_document_id fk_bac_ins_f_au_demolition_permit_on_floor_plan_document R
bac_ins_f_au_demolition_permit.form_document_id fk_bac_ins_f_au_demolition_permit_on_form_document R
bac_ins_f_au_demolition_permit.has_demolition_permit_id fk_bac_ins_f_au_demolition_permit_on_has_demolition_permit R
bac_ins_f_au_demolition_permit.site_plan_document_id fk_bac_ins_f_au_demolition_permit_on_site_plan_document R
bac_ins_f_au_develop_permit.camping_light_leisure_housing_id fk_bac_ins_f_au_develop_permit_on_camping_light_leisure_housing R
bac_ins_f_au_develop_permit.composition_development_description_document_id fk_bacinsfaudeveloppermit_on_compositiondevelopmentdescription R
bac_ins_f_au_develop_permit.develop_description_document_id fk_bac_ins_f_au_develop_permit_on_develop_description_document R
bac_ins_f_au_develop_permit.existing_development_description_document_id fk_bacinsfaudeveloppermit_on_existingdevelopmentdescriptiondoc R
bac_ins_f_au_develop_permit.form_document_id fk_bac_ins_f_au_develop_permit_on_form_document R
bac_ins_f_au_develop_permit.has_develop_permit_id fk_bac_ins_f_au_develop_permit_on_has_develop_permit R
bac_ins_f_au_develop_permit.site_plan_document_id fk_bac_ins_f_au_develop_permit_on_site_plan_document R
bac_ins_f_au_develop_permit.subdivision_application_building_complection_deferred_id fk_bacinsfaudeveloppermit_on_subdivisionapplicationbuildingcomp R
bac_ins_f_au_public_domain.connectable_to_public_domain_id fk_bac_ins_f_au_public_domain_on_connectable_to_public_domain R
bac_ins_f_au_public_domain.department_decision_id fk_bac_ins_f_au_public_domain_on_department_decision R
bac_ins_f_au_public_domain.effluent_type_generated_id fk_bac_ins_f_au_public_domain_on_effluent_type_generated R
bac_ins_f_au_public_domain.land_served_by_sewer_id fk_bac_ins_f_au_public_domain_on_land_served_by_sewer R
bac_ins_f_au_public_domain.network_extension_planned_id fk_bac_ins_f_au_public_domain_on_network_extension_planned R
bac_ins_f_au_public_domain.sewage_network_accept_additional_wastewater_id fk_bacinsfaupublicdomain_on_sewagenetworkacceptadditionalwastew R
bac_ins_f_au_public_domain.treatment_plant_accept_additional_wastewater_id fk_bacinsfaupublicdomain_on_treatmentplantacceptadditionalwaste R
bac_ins_f_au_public_domain.wastewater_treatment_system_compliant_id fk_bacinsfaupublicdomain_on_wastewatertreatmentsystemcompliant R
bac_ins_f_au_public_domain.wastewater_treatment_system_restrictions_id fk_bacinsfaupublicdomain_on_wastewatertreatmentsystemrestrictio R
bac_ins_f_au_rainwater.rainwater_connection_box_installed_id fk_bac_ins_f_au_rainwater_on_rainwater_connection_box_installed R
bac_ins_f_au_rainwater.rainwater_outlet_id fk_bac_ins_f_au_rainwater_on_rainwater_outlet R
bac_ins_f_au_rainwater.retention_planned_in_land_id fk_bac_ins_f_au_rainwater_on_retention_planned_in_land R
bac_ins_f_au_request_characteristic.completed_area_than_declared_area_id fk_bacinsfaurequestcharacterist_on_completedareathandeclaredare R
bac_ins_f_au_request_characteristic.contribution_type_id fk_bac_ins_f_au_request_characteristic_on_contribution_type R
bac_ins_f_au_request_characteristic.instalments_payment_id fk_bac_ins_f_au_request_characteristic_on_instalments_payment R
bac_ins_f_au_request_characteristic.other_document_id fk_bac_ins_f_au_request_characteristic_on_other_document R
bac_ins_f_au_request_characteristic.payment_id fk_bac_ins_f_au_request_characteristic_on_payment R
bac_ins_f_au_request_characteristic.status_pfac_id fk_bac_ins_f_au_request_characteristic_on_status_pfac R
bac_ins_f_au_request_characteristic_area.usage_id fk_bac_ins_f_au_request_characteristic_area_on_usage R
bac_ins_f_au_urbanism_certificate.authorization_connect_to_existing_private_network_id fk_bacinsfauurbanismcertificate_on_authorizationconnecttoexisti R
bac_ins_f_au_urbanism_certificate.authorization_order_connection_to_wastewater_id fk_bacinsfauurbanismcertificate_on_authorizationorderconnection R
bac_ins_f_au_urbanism_certificate.brief_descriptive_note_document_id fk_bacinsfauurbanismcertificate_on_briefdescriptivenotedocument R
bac_ins_f_au_urbanism_certificate.building_permit_id fk_bac_ins_f_au_urbanism_certificate_on_building_permit R
bac_ins_f_au_urbanism_certificate.existing_connection_to_wastewater_id fk_bacinsfauurbanismcertificate_on_existingconnectiontowastewat R
bac_ins_f_au_urbanism_certificate.incomplete_administrative_file_for_existing_connection_id fk_bacinsfauurbanismcertificate_on_incompleteadministrativefile R
bac_ins_f_au_urbanism_certificate.land_connectable_as_proposed_financial_assistance_id fk_bacinsfauurbanismcertificate_on_landconnectableasproposedfin R
bac_ins_f_au_urbanism_certificate.land_connectable_as_pvr_id fk_bac_ins_f_au_urbanism_certificate_on_land_connectable_as_pvr R
bac_ins_f_au_urbanism_certificate.land_connectable_as_zac_id fk_bac_ins_f_au_urbanism_certificate_on_land_connectable_as_zac R
bac_ins_f_au_urbanism_certificate.land_connected_to_subdivision_network_id fk_bacinsfauurbanismcertificate_on_landconnectedtosubdivisionne R
bac_ins_f_au_urbanism_certificate.land_in_sanitized_zone_id fk_bac_ins_f_au_urbanism_certificate_on_land_in_sanitized_zone R
bac_ins_f_au_urbanism_certificate.land_partially_served_by_sewer_id fk_bacinsfauurbanismcertificate_on_landpartiallyservedbysewer R
bac_ins_f_au_urbanism_certificate.land_served_after_extension_id fk_bacinsfauurbanismcertificate_on_landservedafterextension R
bac_ins_f_au_urbanism_certificate.land_served_after_reinforcement_id fk_bacinsfauurbanismcertificate_on_landservedafterreinforcement R
bac_ins_f_au_urbanism_certificate.land_served_by_sewer_id fk_bac_ins_f_au_urbanism_certificate_on_land_served_by_sewer R
bac_ins_f_au_urbanism_certificate.location_plan_document_id fk_bac_ins_f_au_urbanism_certificate_on_location_plan_document R
bac_ins_f_au_urbanism_certificate.pipe_right_of_way_id fk_bac_ins_f_au_urbanism_certificate_on_pipe_right_of_way R
bac_ins_f_au_urbanism_certificate.planning_certificate_form_document_id fk_bacinsfauurbanismcertificate_on_planningcertificateformdocum R
bac_ins_f_au_urbanism_certificate.sewer_system_sized_to_new_effluent_id fk_bacinsfauurbanismcertificate_on_sewersystemsizedtoneweffluen R
bac_ins_f_au_urbanism_certificate.site_plan_document_id fk_bac_ins_f_au_urbanism_certificate_on_site_plan_document R
bac_ins_f_au_wastewater.connection_lift_pump_required_id fk_bac_ins_f_au_wastewater_on_connection_lift_pump_required R
bac_ins_f_au_wastewater.wastewater_connection_box_installed_id fk_bacinsfauwastewater_on_wastewaterconnectionboxinstalled R
bac_ins_f_au_work_declaration.external_appearance_drawing_document_id fk_bacinsfauworkdeclaration_on_externalappearancedrawingdocumen R
bac_ins_f_au_work_declaration.facade_roof_plan_document_id fk_bac_ins_f_au_work_declaration_on_facade_roof_plan_document R
bac_ins_f_au_work_declaration.form_document_id fk_bac_ins_f_au_work_declaration_on_form_document R
bac_ins_f_au_work_declaration.ground_plan_document_id fk_bac_ins_f_au_work_declaration_on_ground_plan_document R
bac_ins_f_au_work_declaration.section_plan_document_id fk_bac_ins_f_au_work_declaration_on_section_plan_document R
bac_ins_f_au_work_declaration.site_plan_document_id fk_bac_ins_f_au_work_declaration_on_site_plan_document R
bac_ins_f_ci_discharge_connection.establishment_served_by_collective_network_id fk_bacinsfcidischargeconnection_on_establishmentservedbycollect R
bac_ins_f_ci_discharge_connection.establishment_served_by_public_ditch_id fk_bacinsfcidischargeconnection_on_establishmentservedbypublicd R
bac_ins_f_ci_discharge_connection.network_type_combined_water_id fk_bacinsfcidischargeconnection_on_networktypecombinedwater R
bac_ins_f_ci_discharge_connection.network_type_rain_water_id fk_bac_ins_f_ci_discharge_connection_on_network_type_rain_water R
bac_ins_f_ci_discharge_connection.network_type_waste_water_id fk_bacinsfcidischargeconnection_on_networktypewastewater R
bac_ins_f_ci_discharge_points.connection_type_id fk_bac_ins_f_ci_discharge_points_on_connection_type R
bac_ins_f_ci_discharge_points.level_id fk_bac_ins_f_ci_discharge_points_on_level R
bac_ins_f_ci_discharge_points.location_manhole_connection_id fk_bac_ins_f_ci_discharge_points_on_location_manhole_connection R
bac_ins_f_ci_discharge_points.one_way_valve_id fk_bac_ins_f_ci_discharge_points_on_one_way_valve R
bac_ins_f_ci_non_domestic_effluent_type_discharge.acid_ph_water_id fk_bacinsfcinondomesticeffluenttypedischarge_on_acidphwater R
bac_ins_f_ci_non_domestic_effluent_type_discharge.basic_ph_water_id fk_bacinsfcinondomesticeffluenttypedischarge_on_basicphwater R
bac_ins_f_ci_non_domestic_effluent_type_discharge.chlorine_water_id fk_bacinsfcinondomesticeffluenttypedischarge_on_chlorinewater R
bac_ins_f_ci_non_domestic_effluent_type_discharge.cold_water_id fk_bacinsfcinondomesticeffluenttypedischarge_on_coldwater R
bac_ins_f_ci_non_domestic_effluent_type_discharge.diagnostic_study_completed_id fk_bacinsfcinondomesticeffluenttype_on_diagnosticstudycompleted R
bac_ins_f_ci_non_domestic_effluent_type_discharge.hot_water_id fk_bacinsfcinondomesticeffluenttypedischarge_on_hotwater R
bac_ins_f_ci_non_domestic_effluent_type_discharge.hydrocarbon_water_id fk_bacinsfcinondomesticeffluenttypedischarg_on_hydrocarbonwater R
bac_ins_f_ci_non_domestic_effluent_type_discharge.initial_measurement_campaign_carried_out_id fk_bacinsfcinondomesticeffluent_on_initialmeasurementcampaignca R
bac_ins_f_ci_non_domestic_effluent_type_discharge.initial_measurement_campaign_required_id fk_bacinsfcinondomesticeffluent_on_initialmeasurementcampaignre R
bac_ins_f_ci_non_domestic_effluent_type_discharge.micropollutant_water_id fk_bacinsfcinondomesticeffluenttypedisch_on_micropollutantwater R
bac_ins_f_ci_non_domestic_effluent_type_discharge.oily_water_id fk_bacinsfcinondomesticeffluenttypedischarge_on_oilywater R
bac_ins_f_ci_non_domestic_effluent_type_discharge.organic_matter_water_id fk_bacinsfcinondomesticeffluenttypedischa_on_organicmatterwater R
bac_ins_f_ci_non_domestic_effluent_type_discharge.salt_water_id fk_bacinsfcinondomesticeffluenttypedischarge_on_saltwater R
bac_ins_f_ci_non_domestic_effluent_type_discharge.solvent_water_id fk_bacinsfcinondomesticeffluenttypedischarge_on_solventwater R
bac_ins_f_ci_non_domestic_effluent_type_discharge.trace_metal_water_id fk_bacinsfcinondomesticeffluenttypedischarge_on_tracemetalwater R
bac_ins_f_ci_non_domestic_effluent_type_discharge.turbid_water_id fk_bacinsfcinondomesticeffluenttypedischarge_on_turbidwater R
bac_ins_f_ci_other.other_water_ressource_id fk_bac_ins_f_ci_other_on_other_water_ressource R
bac_ins_f_ci_pre_treatment_system.by_product_system_archiving_orders_id fk_bacinsfcipretreatmentsystem_on_byproductsystemarchivingorder R
bac_ins_f_ci_pre_treatment_system.by_product_system_id fk_bac_ins_f_ci_pre_treatment_system_on_by_product_system R
bac_ins_f_ci_pre_treatment_system.existing_id fk_bac_ins_f_ci_pre_treatment_system_on_existing R
bac_ins_f_ci_pre_treatment_system.non_domestic_discharge_register_id fk_bacinsfcipretreatmentsystem_on_nondomesticdischargeregister R
bac_ins_f_ci_provided_document.by_product_acceptance_certificates_id fk_bacinsfciprovideddocument_on_byproductacceptancecertificates R
bac_ins_f_ci_provided_document.cadastral_site_plan_id fk_bac_ins_f_ci_provided_document_on_cadastral_site_plan R
bac_ins_f_ci_provided_document.dimensional_drawing_adjacent_networks_id fk_bacinsfciprovideddocument_on_dimensionaldrawingadjacentnetwo R
bac_ins_f_ci_provided_document.discharge_points_description_id fk_bacinsfciprovideddocument_on_dischargepointsdescription R
bac_ins_f_ci_provided_document.drinking_water_consumption_data_id fk_bacinsfciprovideddocument_on_drinkingwaterconsumptiondata R
bac_ins_f_ci_provided_document.facility_activities_description_id fk_bacinsfciprovideddocument_on_facilityactivitiesdescription R
bac_ins_f_ci_provided_document.initial_measurement_campaign_report_id fk_bacinsfciprovideddocument_on_initialmeasurementcampaignrepor R
bac_ins_f_ci_provided_document.internal_networks_description_id fk_bacinsfciprovideddocument_on_internalnetworksdescription R
bac_ins_f_ci_provided_document.maintenance_contracts_id fk_bac_ins_f_ci_provided_document_on_maintenance_contracts R
bac_ins_f_ci_provided_document.measurement_data_id fk_bac_ins_f_ci_provided_document_on_measurement_data R
bac_ins_f_ci_provided_document.non_domestic_csd_form_id fk_bac_ins_f_ci_provided_document_on_non_domestic_csd_form R
bac_ins_f_ci_provided_document.non_domestic_waste_water_production_data_id fk_bacinsfciprovideddocument_on_nondomesticwastewaterproduction R
bac_ins_f_ci_provided_document.plant_product_safety_data_sheets_id fk_bacinsfciprovideddocument_on_plantproductsafetydatasheets R
bac_ins_f_ci_provided_document.pre_treatment_facility_management_id fk_bacinsfciprovideddocument_on_pretreatmentfacilitymanagement R
bac_ins_f_ci_provided_document.pre_treatment_system_description_id fk_bacinsfciprovideddocument_on_pretreatmentsystemdescription R
bac_ins_f_ci_provided_document.prefectoral_decree_icpe_id fk_bac_ins_f_ci_provided_document_on_prefectoral_decree_icpe R
bac_ins_f_ci_rain_water_discharge_inspection.decision_id fk_bac_ins_f_ci_rain_water_discharge_inspection_on_decision R
bac_ins_f_ci_rain_water_discharge_inspection.discharge_origin_id fk_bacinsfcirainwaterdischargeinspection_on_dischargeorigin R
bac_ins_f_ci_rain_water_discharge_inspection.effluent_characteristics_id fk_bacinsfcirainwaterdischargeinspec_on_effluentcharacteristics R
bac_ins_f_ci_rain_water_discharge_inspection.maintenance_id fk_bac_ins_f_ci_rain_water_discharge_inspection_on_maintenance R
bac_ins_f_ci_rain_water_discharge_inspection.structure_type_id fk_bacinsfcirainwaterdischargeinspection_on_structuretype R
bac_ins_f_ci_used_product.discharge_risk_into_public_sewage_system_id fk_bacinsfciusedproduct_on_dischargeriskintopublicsewagesystem R
bac_ins_f_ci_used_product.environmental_toxicity_id fk_bac_ins_f_ci_used_product_on_environmental_toxicity R
bac_ins_f_ci_used_product.hazardous_product_storage_id fk_bac_ins_f_ci_used_product_on_hazardous_product_storage R
bac_ins_f_ci_used_product.product_safety_sheet_transmitted_id fk_bacinsfciusedproduct_on_productsafetysheettransmitted R
bac_ins_f_ci_waste_products.waste_product_storage_id fk_bac_ins_f_ci_waste_products_on_waste_product_storage R
bac_ins_f_ci_waste_water_discharge_inspection.decision_id fk_bac_ins_f_ci_waste_water_discharge_inspection_on_decision R
bac_ins_f_ci_waste_water_discharge_inspection.discharge_origin_id fk_bacinsfciwastewaterdischargeinspection_on_dischargeorigin R
bac_ins_f_ci_waste_water_discharge_inspection.effluent_characteristics_id fk_bacinsfciwastewaterdischargeinspe_on_effluentcharacteristics R
bac_ins_f_ci_waste_water_discharge_inspection.maintenance_id fk_bac_ins_f_ci_waste_water_discharge_inspection_on_maintenance R
bac_ins_f_ci_waste_water_discharge_inspection.structure_type_id fk_bacinsfciwastewaterdischargeinspection_on_structuretype R
bac_ins_f_ci_water_fee.domestic_pollution_fee_id fk_bac_ins_f_ci_water_fee_on_domestic_pollution_fee R
bac_ins_f_ci_water_fee.non_domestic_pollution_fee_id fk_bac_ins_f_ci_water_fee_on_non_domestic_pollution_fee R
bac_ins_f_ci_water_fee.other_fee_id fk_bac_ins_f_ci_water_fee_on_other_fee R
bac_ins_f_ci_water_fee.withdrawal_from_water_resources_fee_id fk_bacinsfciwaterfee_on_withdrawalfromwaterresourcesfee R
bac_ins_f_ci_water_origin_usage.origin_id fk_bac_ins_f_ci_water_origin_usage_on_origin R
bac_ins_f_ci_water_origin_usage.plan_id fk_bac_ins_f_ci_water_origin_usage_on_plan R
bac_ins_f_ci_water_origin_usage.usage_id fk_bac_ins_f_ci_water_origin_usage_on_usage R
bac_ins_f_ciicpe.plan_id fk_bac_ins_f_ciicpe_on_plan R
bac_ins_f_db.building_type_id fk_bac_ins_f_db_on_building_type R
bac_ins_f_db.connection_lift_pump_required_id fk_bac_ins_f_db_on_connection_lift_pump_required R
bac_ins_f_db.connection_nature_id fk_bac_ins_f_db_on_connection_nature R
bac_ins_f_db.housing_type_id fk_bac_ins_f_db_on_housing_type R
bac_ins_f_db.request_nature_id fk_bac_ins_f_db_on_request_nature R
bac_ins_f_db.request_origin_id fk_bac_ins_f_db_on_request_origin R
bac_ins_f_db.usage_type_id fk_bac_ins_f_db_on_usage_type R
bac_ins_f_db_dates.collection_period_id fk_bac_ins_f_db_dates_on_collection_period R
bac_ins_f_db_manhole.connection_nature_id fk_bac_ins_f_db_manhole_on_connection_nature R
bac_ins_f_db_provided_doc.certificate_of_conformity_id fk_bac_ins_f_db_provided_doc_on_certificate_of_conformity R
bac_ins_f_db_provided_doc.complete_file_id fk_bac_ins_f_db_provided_doc_on_complete_file R
bac_ins_f_db_provided_doc.invoice_id fk_bac_ins_f_db_provided_doc_on_invoice R
bac_ins_f_db_provided_doc.other_id fk_bac_ins_f_db_provided_doc_on_other R
bac_ins_f_db_provided_doc.purchase_order_number_id fk_bac_ins_f_db_provided_doc_on_purchase_order_number R
bac_ins_f_db_provided_doc.quotation_id fk_bac_ins_f_db_provided_doc_on_quotation R
bac_ins_f_db_provided_doc.signed_connection_request_id fk_bac_ins_f_db_provided_doc_on_signed_connection_request R
bac_ins_f_dc.counter_inspection_id fk_bac_ins_f_dc_on_counter_inspection R
bac_ins_f_dc.inspection_type_id fk_bac_ins_f_dc_on_inspection_type R
bac_ins_f_dc.meteo_id fk_bac_ins_f_dc_on_meteo R
bac_ins_f_dc.passage_through_private_property_id fk_bac_ins_f_dc_on_passage_through_private_property R
bac_ins_f_dc.written_authorisation_from_owner_provided_id fk_bac_ins_f_dc_on_written_authorisation_from_owner_provided R
bac_ins_f_dc_anomaly.corrected_anomalies_id fk_bac_ins_f_dc_anomaly_on_corrected_anomalies R
bac_ins_f_dc_anomaly.no_anomaly_id fk_bac_ins_f_dc_anomaly_on_no_anomaly R
bac_ins_f_dc_anomaly.rainwater_floor_drain_anomaly_id fk_bac_ins_f_dc_anomaly_on_rainwater_floor_drain_anomaly R
bac_ins_f_dc_anomaly.rainwater_gutter_anomaly_id fk_bac_ins_f_dc_anomaly_on_rainwater_gutter_anomaly R
bac_ins_f_dc_anomaly.rainwater_gutter_grate_anomaly_id fk_bac_ins_f_dc_anomaly_on_rainwater_gutter_grate_anomaly R
bac_ins_f_dc_anomaly.rainwater_in_separative_wastewater_id fk_bac_ins_f_dc_anomaly_on_rainwater_in_separative_wastewater R
bac_ins_f_dc_anomaly.rainwater_no_compulsory_preprocessing_id fk_bacinsfdcanomaly_on_rainwaternocompulsorypreprocessing R
bac_ins_f_dc_anomaly.rainwater_not_complied_planning_permission_id fk_bacinsfdcanomaly_on_rainwaternotcompliedplanningpermission R
bac_ins_f_dc_anomaly.rainwater_other_anomaly_id fk_bac_ins_f_dc_anomaly_on_rainwater_other_anomaly R
bac_ins_f_dc_anomaly.rainwater_siphonic_drain_anomaly_id fk_bac_ins_f_dc_anomaly_on_rainwater_siphonic_drain_anomaly R
bac_ins_f_dc_anomaly.waste_and_rainw_m_p_a_before_combined_sewer_system_via_gutter_i fk_bacinsfdcanomaly_on_wasteandrainwmpabeforecombinedsewersyste R
bac_ins_f_dc_anomaly.wastewater_building_not_connected_id fk_bac_ins_f_dc_anomaly_on_wastewater_building_not_connected R
bac_ins_f_dc_anomaly.wastewater_flows_into_combined_sewer_system_via_gutter_id fk_bacinsfdcanomaly_on_wastewaterflowsintocombinedsewersystemvi R
bac_ins_f_dc_anomaly.wastewater_found_in_pit_id fk_bac_ins_f_dc_anomaly_on_wastewater_found_in_pit R
bac_ins_f_dc_anomaly.wastewater_in_separative_rainwater_id fk_bac_ins_f_dc_anomaly_on_wastewater_in_separative_rainwater R
bac_ins_f_dc_anomaly.wastewater_infiltration_of_parasitic_water_id fk_bacinsfdcanomaly_on_wastewaterinfiltrationofparasiticwater R
bac_ins_f_dc_anomaly.wastewater_intermediate_decantation_structure_id fk_bacinsfdcanomaly_on_wastewaterintermediatedecantationstructu R
bac_ins_f_dc_anomaly.wastewater_leakage_in_structure_id fk_bac_ins_f_dc_anomaly_on_wastewater_leakage_in_structure R
bac_ins_f_dc_anomaly.wastewater_no_compulsory_preprocessing_id fk_bacinsfdcanomaly_on_wastewaternocompulsorypreprocessing R
bac_ins_f_dc_anomaly.wastewater_not_found_id fk_bac_ins_f_dc_anomaly_on_wastewater_not_found R
bac_ins_f_dc_anomaly.wastewater_other_anomaly_id fk_bac_ins_f_dc_anomaly_on_wastewater_other_anomaly R
bac_ins_f_dc_anomaly.wastewater_possible_into_pit_id fk_bac_ins_f_dc_anomaly_on_wastewater_possible_into_pit R
bac_ins_f_dc_anomaly.wastewater_sewage_in_soil_id fk_bac_ins_f_dc_anomaly_on_wastewater_sewage_in_soil R
bac_ins_f_dc_building.backflow_prevention_valve_id fk_bac_ins_f_dc_building_on_backflow_prevention_valve R
bac_ins_f_dc_building.backflow_station_id fk_bac_ins_f_dc_building_on_backflow_station R
bac_ins_f_dc_building.basement_id fk_bac_ins_f_dc_building_on_basement R
bac_ins_f_dc_building.building_type_id fk_bac_ins_f_dc_building_on_building_type R
bac_ins_f_dc_building.cellar_id fk_bac_ins_f_dc_building_on_cellar R
bac_ins_f_dc_building.controlled_measuring_device_id fk_bac_ins_f_dc_building_on_controlled_measuring_device R
bac_ins_f_dc_building.crawl_space_id fk_bac_ins_f_dc_building_on_crawl_space R
bac_ins_f_dc_building.drinking_water_pretreatment_system_id fk_bac_ins_f_dc_building_on_drinking_water_pretreatment_system R
bac_ins_f_dc_building.drinking_water_regulation_id fk_bac_ins_f_dc_building_on_drinking_water_regulation R
bac_ins_f_dc_building.flood_zone_id fk_bac_ins_f_dc_building_on_flood_zone R
bac_ins_f_dc_building.housing_type_id fk_bac_ins_f_dc_building_on_housing_type R
bac_ins_f_dc_building.macerator_toilet_id fk_bac_ins_f_dc_building_on_macerator_toilet R
bac_ins_f_dc_building.municipal_declaration_id fk_bac_ins_f_dc_building_on_municipal_declaration R
bac_ins_f_dc_building.nature_id fk_bac_ins_f_dc_building_on_nature R
bac_ins_f_dc_building.non_collective_sanitation_system_id fk_bac_ins_f_dc_building_on_non_collective_sanitation_system R
bac_ins_f_dc_building.primary_ventilation_id fk_bac_ins_f_dc_building_on_primary_ventilation R
bac_ins_f_dc_building.private_water_catchment_id fk_bac_ins_f_dc_building_on_private_water_catchment R
bac_ins_f_dc_building.rain_water_separated_id fk_bac_ins_f_dc_building_on_rain_water_separated R
bac_ins_f_dc_building.rainwater_collector_id fk_bac_ins_f_dc_building_on_rainwater_collector R
bac_ins_f_dc_building.sink_macerator_id fk_bac_ins_f_dc_building_on_sink_macerator R
bac_ins_f_dc_building.swimming_pool_id fk_bac_ins_f_dc_building_on_swimming_pool R
bac_ins_f_dc_building.usage_type_id fk_bac_ins_f_dc_building_on_usage_type R
bac_ins_f_dc_building.vent_id fk_bac_ins_f_dc_building_on_vent R
bac_ins_f_dc_building.waste_water_connected_id fk_bac_ins_f_dc_building_on_wast_water_connected R
bac_ins_f_dc_building.waste_water_pretreatment_system_id fk_bac_ins_f_dc_building_on_waste_water_pretreatment_system R
bac_ins_f_dc_building.water_for_human_consumption_id fk_bac_ins_f_dc_building_on_water_for_human_consumption R
bac_ins_f_dc_building.water_supply_nature_id fk_bac_ins_f_dc_building_on_water_supply_nature R
bac_ins_f_dc_man_hole.rain_water_id fk_bac_ins_f_dc_man_hole_on_rain_water R
bac_ins_f_dc_man_hole.rain_water_network_type_id fk_bac_ins_f_dc_man_hole_on_rain_water_network_type R
bac_ins_f_dc_man_hole.waste_water_id fk_bac_ins_f_dc_man_hole_on_waste_water R
bac_ins_f_dc_man_hole.waste_water_network_type_id fk_bac_ins_f_dc_man_hole_on_waste_water_network_type R
bac_ins_f_dc_private_domain.backflow_trap_id fk_bac_ins_f_dc_private_domain_on_backflow_trap R
bac_ins_f_dc_private_domain.backflow_trap_state_id fk_bac_ins_f_dc_private_domain_on_backflow_trap_state R
bac_ins_f_dc_private_domain.cleaning_manhole_id fk_bac_ins_f_dc_private_domain_on_cleaning_manhole R
bac_ins_f_dc_private_domain.cleaning_manhole_state_id fk_bac_ins_f_dc_private_domain_on_cleaning_manhole_state R
bac_ins_f_dc_private_domain.connection_manhole_id fk_bac_ins_f_dc_private_domain_on_connection_manhole R
bac_ins_f_dc_private_domain.connection_manhole_state_id fk_bac_ins_f_dc_private_domain_on_connection_manhole_state R
bac_ins_f_dc_private_domain.cover_manhole_id fk_bac_ins_f_dc_private_domain_on_cover_manhole R
bac_ins_f_dc_private_domain.cover_manhole_state_id fk_bac_ins_f_dc_private_domain_on_cover_manhole_state R
bac_ins_f_dc_private_domain.lifting_station_alarm_id fk_bac_ins_f_dc_private_domain_on_lifting_station_alarm R
bac_ins_f_dc_private_domain.lifting_station_drain_done_id fk_bac_ins_f_dc_private_domain_on_lifting_station_drain_done R
bac_ins_f_dc_private_domain.lifting_station_drain_state_id fk_bac_ins_f_dc_private_domain_on_lifting_station_drain_state R
bac_ins_f_dc_private_domain.lifting_station_id fk_bac_ins_f_dc_private_domain_on_lifting_station R
bac_ins_f_dc_private_domain.lifting_station_material_id fk_bac_ins_f_dc_private_domain_on_lifting_station_material R
bac_ins_f_dc_private_domain.lifting_station_ventilation_id fk_bac_ins_f_dc_private_domain_on_lifting_station_ventilation R
bac_ins_f_dc_private_domain.property_access_id fk_bac_ins_f_dc_private_domain_on_property_access R
bac_ins_f_dc_private_domain.rainwater_box_connected_accessible_id fk_bacinsfdcprivatedomain_on_rainwaterboxconnectedaccessible R
bac_ins_f_dc_private_domain.rainwater_location_id fk_bac_ins_f_dc_private_domain_on_rainwater_location R
bac_ins_f_dc_private_domain.right_of_way_id fk_bac_ins_f_dc_private_domain_on_right_of_way R
bac_ins_f_dc_private_domain.wastewater_box_connected_accessible_id fk_bacinsfdcprivatedomain_on_wastewaterboxconnectedaccessible R
bac_ins_f_dc_private_domain.wastewater_location_id fk_bac_ins_f_dc_private_domain_on_wastewater_location R
bac_ins_f_dc_private_domain_rainwater_drainage.combined_collector_id fk_bacinsfdcprivatedomainrainwaterdrainage_on_combinedcollector R
bac_ins_f_dc_private_domain_rainwater_drainage.compliance_id fk_bac_ins_f_dc_private_domain_rainwater_drainage_on_compliance R
bac_ins_f_dc_private_domain_rainwater_drainage.connection_box_id fk_bacinsfdcprivatedomainrainwaterdrainage_on_connectionbox R
bac_ins_f_dc_private_domain_rainwater_drainage.gutter_id fk_bac_ins_f_dc_private_domain_rainwater_drainage_on_gutter R
bac_ins_f_dc_private_domain_rainwater_drainage.land_id fk_bac_ins_f_dc_private_domain_rainwater_drainage_on_land R
bac_ins_f_dc_private_domain_rainwater_drainage.manhole_cover_id fk_bacinsfdcprivatedomainrainwaterdrainage_on_manholecover R
bac_ins_f_dc_private_domain_rainwater_drainage.non_domestic_waste_id fk_bacinsfdcprivatedomainrainwaterdrainage_on_nondomesticwaste R
bac_ins_f_dc_private_domain_rainwater_drainage.oil_separator_id fk_bacinsfdcprivatedomainrainwaterdrainage_on_oilseparator R
bac_ins_f_dc_private_domain_rainwater_drainage.open_ditch_id fk_bac_ins_f_dc_private_domain_rainwater_drainage_on_open_ditch R
bac_ins_f_dc_private_domain_rainwater_drainage.other_id fk_bac_ins_f_dc_private_domain_rainwater_drainage_on_other R
bac_ins_f_dc_private_domain_rainwater_drainage.preprocessing_id fk_bacinsfdcprivatedomainrainwaterdrainage_on_preprocessing R
bac_ins_f_dc_private_domain_rainwater_drainage.preprocessing_type_id fk_bacinsfdcprivatedomainrainwaterdrainage_on_preprocessingtype R
bac_ins_f_dc_private_domain_rainwater_drainage.rainwater_collector_id fk_bacinsfdcprivatedomainrainwaterdrainag_on_rainwatercollector R
bac_ins_f_dc_private_domain_rainwater_drainage.retention_basin_id fk_bacinsfdcprivatedomainrainwaterdrainage_on_retentionbasin R
bac_ins_f_dc_private_domain_rainwater_drainage.waste_type fk_bac_ins_f_dc_private_domain_rainwater_drainage_on_waste_type R
bac_ins_f_dc_private_domain_rainwater_drainage.wastewater_collector_id fk_bacinsfdcprivatedomainrainwaterdraina_on_wastewatercollector R
bac_ins_f_dc_private_domain_rainwater_installatio.building_id fk_bacinsfdcprivatedomainrainwaterinstallatio_on_building R
bac_ins_f_dc_private_domain_rainwater_installatio.compliance_id fk_bacinsfdcprivatedomainrainwaterinstallatio_on_compliance R
bac_ins_f_dc_private_domain_rainwater_installatio.destination_id fk_bacinsfdcprivatedomainrainwaterinstallatio_on_destination R
bac_ins_f_dc_private_domain_rainwater_installatio.equipment_id fk_bacinsfdcprivatedomainrainwaterinstallatio_on_equipment R
bac_ins_f_dc_private_domain_rainwater_installatio.location_id fk_bacinsfdcprivatedomainrainwaterinstallatio_on_location R
bac_ins_f_dc_private_domain_rainwater_installatio.situation_id fk_bacinsfdcprivatedomainrainwaterinstallatio_on_situation R
bac_ins_f_dc_private_domain_rainwater_installatio.test_type_id fk_bacinsfdcprivatedomainrainwaterinstallatio_on_testtype R
bac_ins_f_dc_private_domain_wastewater_drainage.combined_collector_id fk_bacinsfdcprivatedomainwastewaterdrainag_on_combinedcollector R
bac_ins_f_dc_private_domain_wastewater_drainage.compliance_id fk_bacinsfdcprivatedomainwastewaterdrainage_on_compliance R
bac_ins_f_dc_private_domain_wastewater_drainage.connection_box_id fk_bacinsfdcprivatedomainwastewaterdrainage_on_connectionbox R
bac_ins_f_dc_private_domain_wastewater_drainage.gutter_id fk_bac_ins_f_dc_private_domain_wastewater_drainage_on_gutter R
bac_ins_f_dc_private_domain_wastewater_drainage.land_id fk_bac_ins_f_dc_private_domain_wastewater_drainage_on_land R
bac_ins_f_dc_private_domain_wastewater_drainage.manhole_cover_id fk_bacinsfdcprivatedomainwastewaterdrainage_on_manholecover R
bac_ins_f_dc_private_domain_wastewater_drainage.non_domestic_waste_id fk_bacinsfdcprivatedomainwastewaterdrainage_on_nondomesticwaste R
bac_ins_f_dc_private_domain_wastewater_drainage.oil_separator_id fk_bacinsfdcprivatedomainwastewaterdrainage_on_oilseparator R
bac_ins_f_dc_private_domain_wastewater_drainage.open_ditch_id fk_bacinsfdcprivatedomainwastewaterdrainage_on_openditch R
bac_ins_f_dc_private_domain_wastewater_drainage.other_id fk_bac_ins_f_dc_private_domain_wastewater_drainage_on_other R
bac_ins_f_dc_private_domain_wastewater_drainage.preprocessing_id fk_bacinsfdcprivatedomainwastewaterdrainage_on_preprocessing R
bac_ins_f_dc_private_domain_wastewater_drainage.preprocessing_type_id fk_bacinsfdcprivatedomainwastewaterdrainag_on_preprocessingtype R
bac_ins_f_dc_private_domain_wastewater_drainage.rainwater_collector_id fk_bacinsfdcprivatedomainwastewaterdraina_on_rainwatercollector R
bac_ins_f_dc_private_domain_wastewater_drainage.retention_basin_id fk_bacinsfdcprivatedomainwastewaterdrainage_on_retentionbasin R
bac_ins_f_dc_private_domain_wastewater_drainage.waste_type fk_bacinsfdcprivatedomainwastewaterdrainage_on_wastetype R
bac_ins_f_dc_private_domain_wastewater_drainage.wastewater_collector_id fk_bacinsfdcprivatedomainwastewaterdrain_on_wastewatercollector R
bac_ins_f_dc_private_domain_wastewater_installati.building_id fk_bacinsfdcprivatedomainwastewaterinstallati_on_building R
bac_ins_f_dc_private_domain_wastewater_installati.compliance_id fk_bacinsfdcprivatedomainwastewaterinstallati_on_compliance R
bac_ins_f_dc_private_domain_wastewater_installati.destination_id fk_bacinsfdcprivatedomainwastewaterinstallati_on_destination R
bac_ins_f_dc_private_domain_wastewater_installati.equipment_id fk_bacinsfdcprivatedomainwastewaterinstallati_on_equipment R
bac_ins_f_dc_private_domain_wastewater_installati.location_id fk_bacinsfdcprivatedomainwastewaterinstallati_on_location R
bac_ins_f_dc_private_domain_wastewater_installati.situation_id fk_bacinsfdcprivatedomainwastewaterinstallati_on_situation R
bac_ins_f_dc_private_domain_wastewater_installati.test_type_id fk_bacinsfdcprivatedomainwastewaterinstallati_on_testtype R
bac_ins_f_dc_provided_document.other_id fk_bac_ins_f_dc_provided_document_on_other R
bac_ins_f_dc_provided_document.plans_id fk_bac_ins_f_dc_provided_document_on_plans R
bac_ins_f_dc_provided_document.quote_id fk_bac_ins_f_dc_provided_document_on_quote R
bac_ins_f_dc_provided_document.water_bill_id fk_bac_ins_f_dc_provided_document_on_water_bill R
bac_ins_f_dc_provided_document.work_invoice_id fk_bac_ins_f_dc_provided_document_on_work_invoice R
bac_ins_f_dc_provided_document.work_photos_id fk_bac_ins_f_dc_provided_document_on_work_photos R
bac_ins_f_dc_provided_document.work_start_declaration_id fk_bac_ins_f_dc_provided_document_on_work_start_declaration R
bac_ins_f_dc_public_domain.box_buffer_secure_good_condition_id fk_bacinsfdcpublicdomain_on_boxbuffersecuregoodcondition R
bac_ins_f_dc_public_domain.box_correct_flow_through_manhole_id fk_bacinsfdcpublicdomain_on_boxcorrectflowthroughmanhole R
bac_ins_f_dc_public_domain.box_sufficient_pipe_slope_id fk_bac_ins_f_dc_public_domain_on_box_sufficient_pipe_slope R
bac_ins_f_dc_public_domain.box_technical_specifications_complied_id fk_bacinsfdcpublicdomain_on_boxtechnicalspecificationscomplied R
bac_ins_f_dc_public_domain.box_tightness_box_id fk_bac_ins_f_dc_public_domain_on_box_tightness_box R
bac_ins_f_dc_public_domain.connection_made_id fk_bac_ins_f_dc_public_domain_on_connection_made R
bac_ins_f_dc_public_domain.connection_possible_id fk_bac_ins_f_dc_public_domain_on_connection_possible R
bac_ins_f_dc_public_domain.housing_connectable_id fk_bac_ins_f_dc_public_domain_on_housing_connectable R
bac_ins_f_dc_public_domain.housing_connection_id fk_bac_ins_f_dc_public_domain_on_housing_connection R
bac_ins_f_dc_public_domain.network_type_id fk_bac_ins_f_dc_public_domain_on_network_type R
bac_ins_f_dc_public_domain.rainwater_connected_to_rainwater_network_id fk_bacinsfdcpublicdomain_on_rainwaterconnectedtorainwaternetwor R
bac_ins_f_dc_public_domain_connection.connection_type_id fk_bac_ins_f_dc_public_domain_connection_on_connection_type R
bac_ins_f_dc_public_domain_connection.crossed_by_collector_id fk_bacinsfdcpublicdomainconnection_on_crossedbycollector R
bac_ins_f_dc_public_domain_connection.easement_id fk_bac_ins_f_dc_public_domain_connection_on_easement R
bac_ins_f_dc_public_domain_connection.material_id fk_bac_ins_f_dc_public_domain_connection_on_material R
bac_ins_f_dc_public_domain_connection.nature_id fk_bac_ins_f_dc_public_domain_connection_on_nature R
bac_ins_f_dc_public_domain_connection.only_rainwater_in_rainwater_box_id fk_bacinsfdcpublicdomainconnecti_on_onlyrainwaterinrainwaterbox R
bac_ins_f_dc_public_domain_connection.only_wastewater_in_wastewater_box_id fk_bacinsfdcpublicdomainconnect_on_onlywastewaterinwastewaterbo R
bac_ins_f_dc_public_domain_connection.rainwater_box_connected_to_rainwater_public_network_system_id fk_bacinsfdcpublicdomainconnect_on_rainwaterboxconnectedtorainw R
bac_ins_f_dc_public_domain_connection.rainwater_box_connected_to_wastewater_public_network_system_id fk_bacinsfdcpublicdomainconnect_on_rainwaterboxconnectedtowaste R
bac_ins_f_dc_public_domain_connection.technical_specifications_complied_id fk_bacinsfdcpublicdomainconnect_on_technicalspecificationscompl R
bac_ins_f_dc_public_domain_connection.via_other_parcel_id fk_bac_ins_f_dc_public_domain_connection_on_via_other_parcel R
bac_ins_f_dc_public_domain_connection.water_type_id fk_bac_ins_f_dc_public_domain_connection_on_water_type R
bac_ins_f_dc_public_domain_connection_box.box_type_id fk_bac_ins_f_dc_public_domain_connection_box_on_box_type R
bac_ins_f_dc_public_domain_connection_box.location_id fk_bac_ins_f_dc_public_domain_connection_box_on_location R
bac_ins_f_dc_public_domain_connection_box.material_id fk_bac_ins_f_dc_public_domain_connection_box_on_material R
bac_ins_f_dc_public_domain_connection_box.nature_id fk_bac_ins_f_dc_public_domain_connection_box_on_nature R
bac_ins_f_dc_public_domain_connection_box.water_type_id fk_bac_ins_f_dc_public_domain_connection_box_on_water_type R
bac_ins_f_dc_tests.other_test_id fk_bac_ins_f_dc_tests_on_other_test R
bac_ins_f_dc_tests.smoke_test_id fk_bac_ins_f_dc_tests_on_smoke_test R
bac_ins_f_dc_tests.sound_test_id fk_bac_ins_f_dc_tests_on_sound_test R
bac_ins_f_dc_tests.television_inspection_test_id fk_bac_ins_f_dc_tests_on_television_inspection_test R
bac_ins_f_dc_tests.visual_inspection_id fk_bac_ins_f_dc_tests_on_visual_inspection R
bac_ins_f_dc_tests.water_or_dye_test_id fk_bac_ins_f_dc_tests_on_water_or_dye_test R
deleted_by varchar 255 √ null
deleted_date timestamp 29,6 √ null
code varchar 255 null
name varchar 255 √ null
description varchar 2048 √ null
sort_name varchar 255 √ null
search_key varchar 255 null
best_confidence_origin_id uuid 2147483647 √ null
com_data_origin.id fk_bac_inspection_form_simple_list_on_best_confidence_origin R
icon varchar 255 √ null
color varchar 255 √ 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

Indexes

Constraint Name Type Sort Column(s)
pk_bac_inspection_form_simple_list Primary key Asc id
idx_bac_inspection_form_simple_list_unq Must be unique Asc/Asc code + search_key
idx_bac_inspection_form_simple_list_unq_name Must be unique Asc/Asc name + search_key

Relationships

Close relationships within degrees of separation