bac_ins_f_ci_non_domestic_effluent_type_discharge

39 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_ci.non_domestic_effluent_type_discharged_id fk_bac_ins_f_ci_on_non_domestic_effluent_type_discharged 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_discharge_rates_by_year_m3 int4 10 √ null
diagnostic_study_completed_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcinondomesticeffluenttype_on_diagnosticstudycompleted R
initial_measurement_campaign_carried_out_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcinondomesticeffluent_on_initialmeasurementcampaignca R
initial_measurement_campaign_required_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcinondomesticeffluent_on_initialmeasurementcampaignre R
oily_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcinondomesticeffluenttypedischarge_on_oilywater R
chlorine_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcinondomesticeffluenttypedischarge_on_chlorinewater R
salt_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcinondomesticeffluenttypedischarge_on_saltwater R
hydrocarbon_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcinondomesticeffluenttypedischarg_on_hydrocarbonwater R
turbid_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcinondomesticeffluenttypedischarge_on_turbidwater R
organic_matter_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcinondomesticeffluenttypedischa_on_organicmatterwater R
micropollutant_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcinondomesticeffluenttypedisch_on_micropollutantwater R
trace_metal_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcinondomesticeffluenttypedischarge_on_tracemetalwater R
solvent_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcinondomesticeffluenttypedischarge_on_solventwater R
acid_ph_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcinondomesticeffluenttypedischarge_on_acidphwater R
basic_ph_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcinondomesticeffluenttypedischarge_on_basicphwater R
hot_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcinondomesticeffluenttypedischarge_on_hotwater R
cold_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcinondomesticeffluenttypedischarge_on_coldwater R
comment_ varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_ci_non_domestic_effluent_type_discharge Primary key Asc id
idx_bac_ins_f_cinondome_initialmeasurementcampaigncar Performance Asc initial_measurement_campaign_carried_out_id
idx_bac_ins_f_cinondome_initialmeasurementcampaignreq Performance Asc initial_measurement_campaign_required_id
idx_bac_ins_f_cinondomestice_diagnosticstudycompleted Performance Asc diagnostic_study_completed_id
idx_bac_ins_f_cinondomesticefflue_micropollutantwater Performance Asc micropollutant_water_id
idx_bac_ins_f_cinondomesticeffluen_organicmatterwater Performance Asc organic_matter_water_id
idx_bac_ins_f_cinondomesticeffluentt_hydrocarbonwater Performance Asc hydrocarbon_water_id
idx_bac_ins_f_cinondomesticeffluentty_tracemetalwater Performance Asc trace_metal_water_id
idx_bac_ins_f_cinondomesticeffluenttype_chlorinewater Performance Asc chlorine_water_id
idx_bac_ins_f_cinondomesticeffluenttyped_basicphwater Performance Asc basic_ph_water_id
idx_bac_ins_f_cinondomesticeffluenttyped_solventwater Performance Asc solvent_water_id
idx_bac_ins_f_cinondomesticeffluenttypedi_acidphwater Performance Asc acid_ph_water_id
idx_bac_ins_f_cinondomesticeffluenttypedi_turbidwater Performance Asc turbid_water_id
idx_bac_ins_f_cinondomesticeffluenttypedisc_coldwater Performance Asc cold_water_id
idx_bac_ins_f_cinondomesticeffluenttypedisc_oilywater Performance Asc oily_water_id
idx_bac_ins_f_cinondomesticeffluenttypedisc_saltwater Performance Asc salt_water_id
idx_bac_ins_f_cinondomesticeffluenttypedisch_hotwater Performance Asc hot_water_id

Relationships

Close relationships within degrees of separation