bac_ins_f_ci_pre_treatment_system

39 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_ci.pre_treatment_system_id fk_bac_ins_f_ci_on_pre_treatment_system 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
existing_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_ci_pre_treatment_system_on_existing R
existing_comment varchar 2048 √ null
by_product_system_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_ci_pre_treatment_system_on_by_product_system R
by_product_system_comment varchar 2048 √ null
by_product_system_archiving_orders_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcipretreatmentsystem_on_byproductsystemarchivingorder R
non_domestic_discharge_register_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfcipretreatmentsystem_on_nondomesticdischargeregister R
comment_ varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_ci_pre_treatment_system Primary key Asc id
idx_bac_ins_f_ci_pre_treatment_system_existing Performance Asc existing_id
idx_bac_ins_f_cipretrea_byproductsystemarchivingorder Performance Asc by_product_system_archiving_orders_id
idx_bac_ins_f_cipretreatm_nondomesticdischargeregister Performance Asc non_domestic_discharge_register_id
idx_bac_ins_f_cipretreatmentsystem_byproductsystem Performance Asc by_product_system_id

Relationships

Close relationships within degrees of separation