SchemaSpy Analysis of testdb.public - Constraints Generated by
SchemaSpy
25 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 
fk3l03d64363600clx5swd3nj4q wms_inv_location_log.c_rev wms_inv_revision.c_pk Cascade on delete 
fk3r0c5pcatxo7hsicd6ekferl2 wms_inv_product_unit_detail_log.c_rev wms_inv_revision.c_pk Cascade on delete 
fk6llyhpk51fjpnktmb99via5g2 wms_inv_packaging_unit_detail_log.c_rev wms_inv_revision.c_pk Cascade on delete 
fk8r2s3dnwvi0mxhuj7cvae90u9 wms_inv_product_unit_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_details_pu wms_inv_packaging_unit_detail.c_pu_pk wms_inv_packaging_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_pu_uomrel wms_inv_packaging_unit.c_uom_relation wms_inv_product_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 
fkm2po2n1yu8fsjcvl6nogv77u1 wms_inv_load_unit_log.c_rev wms_inv_revision.c_pk Cascade on delete 
fkohnu07jp5ap56k4v5miwck3gp wms_inv_product_log.c_rev wms_inv_revision.c_pk Cascade on 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