bac_ins_f_ci_water_origin_usage

39 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_ci.water_origin_usage_id fk_bac_ins_f_ci_on_water_origin_usage 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
origin_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_ci_water_origin_usage_on_origin R
connection_reference varchar 255 √ null
water_meter_number varchar 255 √ null
plan_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_ci_water_origin_usage_on_plan R
usage_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_ci_water_origin_usage_on_usage R
water_consumption_m3 int4 10 √ null
comment_ varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_ci_water_origin_usage Primary key Asc id
idx_bac_ins_f_ci_water_origin_usage_origin Performance Asc origin_id
idx_bac_ins_f_ci_water_origin_usage_plan Performance Asc plan_id
idx_bac_ins_f_ci_water_origin_usage_usage Performance Asc usage_id

Relationships

Close relationships within degrees of separation