bac_ins_f_dc_anomaly

99 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_dc.anomaly_id fk_bac_ins_f_dc_on_anomaly 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
no_anomaly_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_anomaly_on_no_anomaly R
corrected_anomalies_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_anomaly_on_corrected_anomalies R
rainwater_in_separative_wastewater_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_anomaly_on_rainwater_in_separative_wastewater R
rainwater_in_separative_wastewater_comment varchar 2048 √ null
rainwater_no_compulsory_preprocessing_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcanomaly_on_rainwaternocompulsorypreprocessing R
rainwater_no_compulsory_preprocessing_comment varchar 2048 √ null
rainwater_not_complied_planning_permission_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcanomaly_on_rainwaternotcompliedplanningpermission R
rainwater_not_complied_planning_permission_comment varchar 2048 √ null
rainwater_gutter_anomaly_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_anomaly_on_rainwater_gutter_anomaly R
rainwater_gutter_anomaly_comment varchar 2048 √ null
rainwater_gutter_grate_anomaly_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_anomaly_on_rainwater_gutter_grate_anomaly R
rainwater_gutter_grate_anomaly_comment varchar 2048 √ null
rainwater_floor_drain_anomaly_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_anomaly_on_rainwater_floor_drain_anomaly R
rainwater_floor_drain_anomaly_comment varchar 2048 √ null
rainwater_siphonic_drain_anomaly_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_anomaly_on_rainwater_siphonic_drain_anomaly R
rainwater_siphonic_drain_anomaly_comment varchar 2048 √ null
rainwater_other_anomaly_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_anomaly_on_rainwater_other_anomaly R
rainwater_other_anomaly_comment varchar 2048 √ null
rainwater_estimated_active_surface_m2 int4 10 √ null
rainwater_anomaly_comment varchar 2048 √ null
wastewater_in_separative_rainwater_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_anomaly_on_wastewater_in_separative_rainwater R
wastewater_in_separative_rainwater_comment varchar 2048 √ null
wastewater_not_found_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_anomaly_on_wastewater_not_found R
wastewater_not_found_comment varchar 2048 √ null
wastewater_possible_into_pit_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_anomaly_on_wastewater_possible_into_pit R
wastewater_possible_into_pit_comment varchar 2048 √ null
wastewater_found_in_pit_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_anomaly_on_wastewater_found_in_pit R
wastewater_found_in_pit_comment varchar 2048 √ null
wastewater_sewage_in_soil_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_anomaly_on_wastewater_sewage_in_soil R
wastewater_sewage_in_soil_comment varchar 2048 √ null
wastewater_leakage_in_structure_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_anomaly_on_wastewater_leakage_in_structure R
wastewater_leakage_in_structure_comment varchar 2048 √ null
wastewater_intermediate_decantation_structure_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcanomaly_on_wastewaterintermediatedecantationstructu R
wastewater_intermediate_decantation_structure_comment varchar 2048 √ null
wastewater_building_not_connected_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_anomaly_on_wastewater_building_not_connected R
wastewater_building_not_connected_comment varchar 2048 √ null
wastewater_no_compulsory_preprocessing_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcanomaly_on_wastewaternocompulsorypreprocessing R
wastewater_no_compulsory_preprocessing_comment varchar 2048 √ null
wastewater_infiltration_of_parasitic_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcanomaly_on_wastewaterinfiltrationofparasiticwater R
wastewater_infiltration_of_parasitic_water_comment varchar 2048 √ null
wastewater_other_anomaly_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_anomaly_on_wastewater_other_anomaly R
wastewater_other_anomaly_comment varchar 2048 √ null
wastewater_anomaly_comment varchar 2048 √ null
wastewater_flows_into_combined_sewer_system_via_gutter_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcanomaly_on_wastewaterflowsintocombinedsewersystemvi R
wastewater_flows_into_combined_sewer_system_via_gutter_comment varchar 2048 √ null
waste_and_rainw_m_p_a_before_combined_sewer_system_via_gutter_i uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcanomaly_on_wasteandrainwmpabeforecombinedsewersyste R
waste_and_rainw_m_p_a_b_c_sewer_system_via_gutter_comment varchar 2048 √ null
anomaly_comment varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_dc_anomaly Primary key Asc id

Relationships

Close relationships within degrees of separation