bac_ins_f_dc_building

99 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_dc.building_id fk_bac_ins_f_dc_on_building 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
nature_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_nature R
crawl_space_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_crawl_space R
nb_occasional_occupants int4 10 √ null
occupation_period int4 10 √ null
nb_service_rooms int4 10 √ null
housing_type_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_housing_type R
building_type_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_building_type R
usage_type_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_usage_type R
building_year varchar 255 √ null
nb_housing_units int4 10 √ null
nb_rooms int4 10 √ null
nb_floors int4 10 √ null
nb_occupants int4 10 √ null
cellar_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_cellar R
basement_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_basement R
water_supply_nature_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_water_supply_nature R
floor_area int4 10 √ null
parcel_area int4 10 √ null
annual_consumption float8 17,17 √ null
water_meter_number varchar 255 √ null
water_meter_reading float8 17,17 √ null
consumption_point varchar 255 √ null
private_water_catchment_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_private_water_catchment R
swimming_pool_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_swimming_pool R
sink_macerator_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_sink_macerator R
non_collective_sanitation_system_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_non_collective_sanitation_system R
backflow_station_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_backflow_station R
backflow_prevention_valve_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_backflow_prevention_valve R
vent_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_vent R
rainwater_collector_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_rainwater_collector R
macerator_toilet_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_macerator_toilet R
primary_ventilation_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_primary_ventilation R
waste_water_pretreatment_system_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_waste_water_pretreatment_system R
drinking_water_pretreatment_system_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_drinking_water_pretreatment_system R
drinking_water_regulation_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_drinking_water_regulation R
comment_ varchar 2048 √ null
annual_consumption_volume varchar 255 √ null
comment_for_land varchar 255 √ null
controlled_measuring_device_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_controlled_measuring_device R
declaration_number varchar 255 √ null
flood_zone_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_flood_zone R
municipal_declaration_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_municipal_declaration R
water_for_human_consumption_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_water_for_human_consumption R
comment_features_eu varchar 255 √ null
installation_age varchar 255 √ null
rain_water_separated_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_rain_water_separated R
waste_water_connected_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_building_on_wast_water_connected R

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_dc_building Primary key Asc id
idx_bac_ins_f_dc_building_backflow_station Performance Asc backflow_station_id
idx_bac_ins_f_dc_building_building_type Performance Asc building_type_id
idx_bac_ins_f_dc_building_controlled_measuring_device Performance Asc controlled_measuring_device_id
idx_bac_ins_f_dc_building_crawl_space Performance Asc crawl_space_id
idx_bac_ins_f_dc_building_declaration_number Performance Asc declaration_number
idx_bac_ins_f_dc_building_flood_zone Performance Asc flood_zone_id
idx_bac_ins_f_dc_building_housing_type Performance Asc housing_type_id
idx_bac_ins_f_dc_building_macerator_toilet Performance Asc macerator_toilet_id
idx_bac_ins_f_dc_building_municipal_declaration Performance Asc municipal_declaration_id
idx_bac_ins_f_dc_building_nature Performance Asc nature_id
idx_bac_ins_f_dc_building_primary_ventilation Performance Asc primary_ventilation_id
idx_bac_ins_f_dc_building_private_water_catchment Performance Asc private_water_catchment_id
idx_bac_ins_f_dc_building_rain_water_separated Performance Asc rain_water_separated_id
idx_bac_ins_f_dc_building_rainwater_collector Performance Asc rainwater_collector_id
idx_bac_ins_f_dc_building_sink_macerator Performance Asc sink_macerator_id
idx_bac_ins_f_dc_building_swimming_pool Performance Asc swimming_pool_id
idx_bac_ins_f_dc_building_usage_type Performance Asc usage_type_id
idx_bac_ins_f_dc_building_vent Performance Asc vent_id
idx_bac_ins_f_dc_building_wast_water_connected Performance Asc waste_water_connected_id
idx_bac_ins_f_dc_building_water_for_human_consumption Performance Asc water_for_human_consumption_id
idx_bac_ins_f_dc_building_water_supply_nature Performance Asc water_supply_nature_id
idx_bac_ins_f_dcbuildin_drinkingwaterpretreatmentsyst Performance Asc drinking_water_pretreatment_system_id
idx_bac_ins_f_dcbuildin_noncollectivesanitationsystem Performance Asc non_collective_sanitation_system_id
idx_bac_ins_f_dcbuilding_backflowpreventionvalve Performance Asc backflow_prevention_valve_id
idx_bac_ins_f_dcbuilding_drinkingwaterregulation Performance Asc drinking_water_regulation_id
idx_bac_ins_f_dcbuilding_wastewaterpretreatmentsystem Performance Asc waste_water_pretreatment_system_id

Relationships

Close relationships within degrees of separation