bac_ins_f_dc_private_domain

99 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_dc.private_domain_id fk_bac_ins_f_dc_on_private_domain R
bac_ins_f_dc_private_domain_rainwater_installatio.private_domain_id fk_bacinsfdcprivatedomainrainwaterinstallatio_on_privatedomain R
bac_ins_f_dc_private_domain_wastewater_installati.private_domain_id fk_bacinsfdcprivatedomainwastewaterinstallati_on_privatedomain 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
property_access_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_property_access R
right_of_way_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_right_of_way R
wastewater_box_connected_accessible_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcprivatedomain_on_wastewaterboxconnectedaccessible R
wastewater_location_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_wastewater_location R
wastewater_location_comment varchar 2048 √ null
rainwater_box_connected_accessible_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcprivatedomain_on_rainwaterboxconnectedaccessible R
rainwater_location_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_rainwater_location R
rainwater_location_comment varchar 2048 √ null
connection_manhole_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_connection_manhole R
connection_manhole_state_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_connection_manhole_state R
cover_manhole_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_cover_manhole R
cover_manhole_state_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_cover_manhole_state R
cleaning_manhole_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_cleaning_manhole R
cleaning_manhole_state_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_cleaning_manhole_state R
backflow_trap_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_backflow_trap R
backflow_trap_state_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_backflow_trap_state R
lifting_station_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_lifting_station R
lifting_station_material_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_lifting_station_material R
lifting_station_volume int4 10 √ null
lifting_station_alarm_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_lifting_station_alarm R
lifting_station_ventilation_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_lifting_station_ventilation R
lifting_station_drain_done_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_lifting_station_drain_done R
lifting_station_drain_state_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_on_lifting_station_drain_state R
connection_comment varchar 2048 √ null
wastewater_drainage_id uuid 2147483647 √ null
bac_ins_f_dc_private_domain_wastewater_drainage.id fk_bac_ins_f_dc_private_domain_on_wastewater_drainage R
rainwater_drainage_id uuid 2147483647 √ null
bac_ins_f_dc_private_domain_rainwater_drainage.id fk_bac_ins_f_dc_private_domain_on_rainwater_drainage R

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_dc_private_domain Primary key Asc id
idx_bac_ins_f_dc_pri__rainwaterboxconnectedaccessib Performance Asc rainwater_box_connected_accessible_id
idx_bac_ins_f_dc_pri__wastewaterboxconnectedaccessi Performance Asc wastewater_box_connected_accessible_id
idx_bac_ins_f_dc_pri_do_backflowtrapstate Performance Asc backflow_trap_state_id
idx_bac_ins_f_dc_pri_do_cleaningmanholestate Performance Asc cleaning_manhole_state_id
idx_bac_ins_f_dc_pri_do_connectionmanholestate Performance Asc connection_manhole_state_id
idx_bac_ins_f_dc_pri_do_covermanholestate Performance Asc cover_manhole_state_id
idx_bac_ins_f_dc_pri_do_liftingstationalarm Performance Asc lifting_station_alarm_id
idx_bac_ins_f_dc_pri_do_liftingstationdraindone Performance Asc lifting_station_drain_done_id
idx_bac_ins_f_dc_pri_do_liftingstationmaterial Performance Asc lifting_station_material_id
idx_bac_ins_f_dc_pri_do_rainwaterlocation Performance Asc rainwater_location_id
idx_bac_ins_f_dc_pri_do_w_ilocation Performance Asc wastewater_location_id
idx_bac_ins_f_dc_pri_doma_liftingstationventilation Performance Asc lifting_station_ventilation_id
idx_bac_ins_f_dc_pri_domai_liftingstationdrainstate Performance Asc lifting_station_drain_state_id
idx_bac_ins_f_dc_private_domain_rainwater_drainage Performance Asc rainwater_drainage_id
idx_bac_ins_f_dc_private_domain_right_of_way Performance Asc right_of_way_id
idx_bac_ins_f_dc_private_domain_wastewater_drainage Performance Asc wastewater_drainage_id

Relationships

Close relationships within degrees of separation