bac_ins_f_au_rainwater

30 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_au.rainwater_id fk_bac_ins_f_au_on_rainwater 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
retention_planned_in_land_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_rainwater_on_retention_planned_in_land R
retention_planned_in_land_comment varchar 2048 √ null
rainwater_connection_box_installed_number int4 10 √ null
rainwater_connection_box_installed_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_rainwater_on_rainwater_connection_box_installed R
depth_m int4 10 √ null
rainwater_outlet_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_au_rainwater_on_rainwater_outlet R
comment varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_au_rainwater Primary key Asc id
idx_bac_ins_f_au_rainwater_connection_box_installed Performance Asc rainwater_connection_box_installed_id
idx_bac_ins_f_au_rainwater_rainwater_outlet Performance Asc rainwater_outlet_id
idx_bac_ins_f_au_rainwater_retention_planned_in_land Performance Asc retention_planned_in_land_id

Relationships

Close relationships within degrees of separation