bac_ins_f_dc_man_hole

99 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_dc.man_hole_id fk_bac_ins_f_dc_on_man_hole 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
waste_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_man_hole_on_waste_water R
waste_water_network_type_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_man_hole_on_waste_water_network_type R
rain_water_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_man_hole_on_rain_water R
rain_water_network_type_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_dc_man_hole_on_rain_water_network_type R
comment_ varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_dc_man_hole Primary key Asc id
idx_bac_ins_f_dc_manhole_rain_w Performance Asc rain_water_id
idx_bac_ins_f_dc_manhole_rain_w_network_type Performance Asc rain_water_network_type_id
idx_bac_ins_f_dc_manhole_waste_w Performance Asc waste_water_id
idx_bac_ins_f_dc_manhole_waste_w_network_type Performance Asc waste_water_network_type_id

Relationships

Close relationships within degrees of separation