bac_ins_f_dc_private_domain_wastewater_drainage

99 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_dc_private_domain.wastewater_drainage_id fk_bac_ins_f_dc_private_domain_on_wastewater_drainage 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
wastewater_collector_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcprivatedomainwastewaterdrain_on_wastewatercollector R
nb_wastewater_collector int4 10 √ null
connection_box_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcprivatedomainwastewaterdrainage_on_connectionbox R
nb_connection_box int4 10 √ null
combined_collector_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcprivatedomainwastewaterdrainag_on_combinedcollector R
manhole_cover_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcprivatedomainwastewaterdrainage_on_manholecover R
rainwater_collector_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcprivatedomainwastewaterdraina_on_rainwatercollector R
preprocessing_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcprivatedomainwastewaterdrainage_on_preprocessing R
preprocessing_type_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcprivatedomainwastewaterdrainag_on_preprocessingtype R
non_domestic_waste_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcprivatedomainwastewaterdrainage_on_nondomesticwaste R
waste_type uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcprivatedomainwastewaterdrainage_on_wastetype R
oil_separator_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcprivatedomainwastewaterdrainage_on_oilseparator R
last_drainage_date date 13 √ null
open_ditch_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcprivatedomainwastewaterdrainage_on_openditch R
retention_basin_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcprivatedomainwastewaterdrainage_on_retentionbasin R
gutter_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_wastewater_drainage_on_gutter R
land_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_wastewater_drainage_on_land R
other_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_private_domain_wastewater_drainage_on_other R
other_description varchar 255 √ null
compliance_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfdcprivatedomainwastewaterdrainage_on_compliance R
comment_ varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_dc_private_domain_wastewater_drainage Primary key Asc id
idx_bac_ins_f_dc_pri_do_w_d_preprocessingtype Performance Asc preprocessing_type_id

Relationships

Close relationships within degrees of separation