bac_ins_f_dc_public_domain_connection

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
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_public_domain_connection_on_nature R
building_date date 13 √ null
water_type_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_public_domain_connection_on_water_type R
building_company_name_id uuid 2147483647 √ null
thirdp_legal_person.id fk_bacinsfdcpublicdomainconnection_on_buildingcompanyname R
easement_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_public_domain_connection_on_easement R
crossed_by_collector_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcpublicdomainconnection_on_crossedbycollector R
via_other_parcel_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_public_domain_connection_on_via_other_parcel R
only_wastewater_in_wastewater_box_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcpublicdomainconnect_on_onlywastewaterinwastewaterbo R
rainwater_box_connected_to_wastewater_public_network_system_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcpublicdomainconnect_on_rainwaterboxconnectedtowaste R
only_rainwater_in_rainwater_box_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcpublicdomainconnecti_on_onlyrainwaterinrainwaterbox R
rainwater_box_connected_to_rainwater_public_network_system_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcpublicdomainconnect_on_rainwaterboxconnectedtorainw R
connection_type_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_public_domain_connection_on_connection_type R
upstream_manifold_water_flow_m float8 17,17 √ null
downstream_manifold_water_flow_m float8 17,17 √ null
main_manifold_water_flow_m float8 17,17 √ null
connection_manifold_water_flow_m float8 17,17 √ null
manhole_diameter_mm int4 10 √ null
observed_structural_state varchar 255 √ null
diameter_cm int4 10 √ null
material_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_public_domain_connection_on_material R
main_drain_length_cm int4 10 √ null
technical_specifications_complied_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcpublicdomainconnect_on_technicalspecificationscompl R
comment_ varchar 2048 √ null
public_domain_id uuid 2147483647 null
bac_ins_f_dc_public_domain.id fk_bac_ins_f_dc_public_domain_connection_on_public_domain R

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_dc_public_domain_connection Primary key Asc id
idx_bac_ins_f_dc_pub_do_c_buildingcompanyname Performance Asc building_company_name_id
idx_bac_ins_f_dc_pub_do_c_crossed_by_collector Performance Asc crossed_by_collector_id
idx_bac_ins_f_dc_pub_do_c_easement Performance Asc easement_id
idx_bac_ins_f_dc_pub_do_c_formdcpublicdomain Performance Asc public_domain_id
idx_bac_ins_f_dc_pub_do_c_material Performance Asc material_id
idx_bac_ins_f_dc_pub_do_c_onlyrainwaterinrainwaterbox Performance Asc only_rainwater_in_rainwater_box_id
idx_bac_ins_f_dc_pub_do_c_onlywastewaterinwastewaterbox Performance Asc only_wastewater_in_wastewater_box_id
idx_bac_ins_f_dc_pub_do_c_rainwaterboxconnectedtorainwa Performance Asc rainwater_box_connected_to_rainwater_public_network_system_id
idx_bac_ins_f_dc_pub_do_c_rainwaterboxconnectedtowastew Performance Asc rainwater_box_connected_to_wastewater_public_network_system_id
idx_bac_ins_f_dc_pub_do_c_technicalspecificationscompli Performance Asc technical_specifications_complied_id
idx_bac_ins_f_dc_pub_do_c_viaotherparcel Performance Asc via_other_parcel_id
idx_bac_ins_f_dc_public_domain_connection_nature Performance Asc nature_id
idx_bac_ins_f_dc_public_domain_connection_water_type Performance Asc water_type_id

Relationships

Close relationships within degrees of separation