bac_ins_f_au_wastewater

30 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_au.wastewater_id fk_bac_ins_f_au_on_wastewater 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_connection_box_installed_number int4 10 √ null
wastewater_connection_box_installed_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfauwastewater_on_wastewaterconnectionboxinstalled R
depth_m int4 10 √ null
connection_lift_pump_required_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_wastewater_on_connection_lift_pump_required R
comment varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_au_wastewater Primary key Asc id
idx_bac_ins_f_au_wastewater_connection_box_installed Performance Asc wastewater_connection_box_installed_id
idx_bac_ins_f_au_wastewater_connection_lift_pump_required Performance Asc connection_lift_pump_required_id

Relationships

Close relationships within degrees of separation