bac_ins_f_ci_used_product

39 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
bac_ins_f_ci.used_product_id fk_bac_ins_f_ci_on_used_product 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
hazardous_product_storage_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_ci_used_product_on_hazardous_product_storage R
reference varchar 255 √ null
product_safety_sheet_transmitted_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfciusedproduct_on_productsafetysheettransmitted R
environmental_toxicity_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bac_ins_f_ci_used_product_on_environmental_toxicity R
discharge_risk_into_public_sewage_system_id uuid 2147483647 √ null
bac_inspection_form_simple_list.id fk_bacinsfciusedproduct_on_dischargeriskintopublicsewagesystem R
comment_ varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_bac_ins_f_ci_used_product Primary key Asc id
idx_bac_ins_f_ciusedpro_dischargeriskintopublicsewage Performance Asc discharge_risk_into_public_sewage_system_id
idx_bac_ins_f_ciusedpro_productsafetysheettransmitted Performance Asc product_safety_sheet_transmitted_id
idx_bac_ins_f_ciusedproduct_environmentaltoxicity Performance Asc environmental_toxicity_id
idx_bac_ins_f_ciusedproduct_hazardousproductstorage Performance Asc hazardous_product_storage_id

Relationships

Close relationships within degrees of separation