SchemaSpy Analysis of testdb.public - Constraints Generated by
SchemaSpy
17 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
fk33u5lgnhso12itvwasgvrvkno wms_inv_reservation_log.c_rev wms_inv_revision.c_pk Cascade on delete 
fk_details_product wms_inv_product_detail.c_product_pk wms_inv_product.c_pk Restrict delete 
fk_details_product_unit wms_inv_product_unit_detail.c_product_unit_pk wms_inv_product_unit.c_pk Restrict delete 
fk_loc_pk wms_inv_transport_unit.c_actual_location wms_inv_location.c_pk Restrict delete 
fk_lu_pk wms_inv_packaging_unit.c_load_unit wms_inv_load_unit.c_pk Restrict delete 
fk_lu_product_pk wms_inv_load_unit.c_product_pk wms_inv_product.c_pk Restrict delete 
fk_lu_tu_pk wms_inv_load_unit.c_transport_unit_pk wms_inv_transport_unit.c_pk Restrict delete 
fk_lut_type wms_inv_load_unit.c_load_unit_type wms_inv_load_unit_type.c_type Restrict delete 
fk_prod_loc_pk wms_inv_product.c_preferable_storage_location wms_inv_location.c_pk Restrict delete 
fk_psr_ap_product wms_inv_product_stacking_rule.c_allowed_product wms_inv_product.c_pk Restrict delete 
fk_psr_bp_product wms_inv_product_stacking_rule.c_base_product wms_inv_product.c_pk Restrict delete 
fk_pu_loc_pk wms_inv_packaging_unit.c_actual_location wms_inv_location.c_pk Restrict delete 
fk_pu_product_pk wms_inv_packaging_unit.c_product_pk wms_inv_product.c_pk Restrict delete 
fk_pu_pu_parent wms_inv_packaging_unit.c_parent wms_inv_packaging_unit.c_pk Restrict delete 
fk_punit_product wms_inv_product_unit.c_product_pk wms_inv_product.c_pk Restrict delete 
fk_pureservation_pk wms_inv_reservation.c_packaging_unit_pk wms_inv_packaging_unit.c_pk Restrict delete 
fkorslxj6jole226itq5c7cy8ax wms_inv_packaging_unit_log.c_rev wms_inv_revision.c_pk Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected