bac_ins_f_ci_discharge_connection

39 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_ci.discharge_connection_id fk_bac_ins_f_ci_on_discharge_connection 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
establishment_served_by_collective_network_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcidischargeconnection_on_establishmentservedbycollect R
network_type_waste_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcidischargeconnection_on_networktypewastewater R
network_type_rain_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_ci_discharge_connection_on_network_type_rain_water R
network_type_combined_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcidischargeconnection_on_networktypecombinedwater R
connection_date date 13 √ null
connection_inspection_date date 13 √ null
establishment_served_by_public_ditch_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcidischargeconnection_on_establishmentservedbypublicd R
comment_ varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_ci_discharge_connection Primary key Asc id
idx_bac_ins_f_cidischar_establishmentservedbycollecti Performance Asc establishment_served_by_collective_network_id
idx_bac_ins_f_cidischar_establishmentservedbypublicdi Performance Asc establishment_served_by_public_ditch_id
idx_bac_ins_f_cidischargecon_networktypecombinedwater Performance Asc network_type_combined_water_id
idx_bac_ins_f_cidischargeconnec_networktypewastewater Performance Asc network_type_waste_water_id
idx_bac_ins_f_cidischargeconnect_networktyperainwater Performance Asc network_type_rain_water_id

Relationships

Close relationships within degrees of separation