Constraints

27 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

fk_punit_product

wms_inv_product_unit.c_product_pk

wms_inv_product.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

fkorslxj6jole226itq5c7cy8ax

wms_inv_packaging_unit_log.c_rev

wms_inv_revision.c_pk

Cascade on delete

fk_pureservation_pk

wms_inv_reservation.c_packaging_unit_pk

wms_inv_packaging_unit.c_pk

Restrict delete

fk6llyhpk51fjpnktmb99via5g2

wms_inv_packaging_unit_detail_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

fk3l03d64363600clx5swd3nj4q

wms_inv_location_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

fk8j2r9hdh93nvyljxgyl0oqoet

wms_inv_tu_reservation_log.c_rev

wms_inv_revision.c_pk

Restrict delete

fk_prod_loc_pk

wms_inv_product.c_preferable_storage_location

wms_inv_location.c_pk

Restrict delete

fkohnu07jp5ap56k4v5miwck3gp

wms_inv_product_log.c_rev

wms_inv_revision.c_pk

Cascade on delete

fk_loc_pk

wms_inv_transport_unit.c_actual_location

wms_inv_location.c_pk

Restrict delete

fkm2po2n1yu8fsjcvl6nogv77u1

wms_inv_load_unit_log.c_rev

wms_inv_revision.c_pk

Cascade on delete

fk_tureservation_pk

wms_inv_tu_reservation.c_transport_unit_pk

wms_inv_transport_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_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_uomrel

wms_inv_packaging_unit.c_uom_relation

wms_inv_product_unit.c_pk

Restrict delete

fk_pu_pu_parent

wms_inv_packaging_unit.c_parent

wms_inv_packaging_unit.c_pk

Restrict delete

fk_pu_product_pk

wms_inv_packaging_unit.c_product_pk

wms_inv_product.c_pk

Restrict delete

fk_lu_pk

wms_inv_packaging_unit.c_load_unit

wms_inv_load_unit.c_pk

Restrict delete

fk_pu_loc_pk

wms_inv_packaging_unit.c_actual_location

wms_inv_location.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

fk33u5lgnhso12itvwasgvrvkno

wms_inv_reservation_log.c_rev

wms_inv_revision.c_pk

Restrict delete

Check Constraints

Table	Constraint Name	Constraint
wms_inv_packaging_unit_log	wms_inv_packaging_unit_log_c_av_state_check	((c_av_state)::text = ANY ((ARRAY['LOCKED'::character varying, 'QC_LOCKED'::character varying, 'AVAILABLE'::character varying])::text[]))
wms_inv_product	wms_inv_product_c_av_state_check	((c_av_state)::text = ANY ((ARRAY['LOCKED'::character varying, 'QC_LOCKED'::character varying, 'AVAILABLE'::character varying])::text[]))
wms_inv_product_log	wms_inv_product_log_c_av_state_check	((c_av_state)::text = ANY ((ARRAY['LOCKED'::character varying, 'QC_LOCKED'::character varying, 'AVAILABLE'::character varying])::text[]))
wms_inv_packaging_unit	wms_inv_packaging_unit_c_av_state_check	((c_av_state)::text = ANY ((ARRAY['LOCKED'::character varying, 'QC_LOCKED'::character varying, 'AVAILABLE'::character varying])::text[]))
wms_inv_replica_registry	wms_inv_replica_registry_c_entity_type_check	((c_entity_type)::text = 'PRODUCT'::text)