Constraints

4 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

fk_rec_pos_product

wms_rec_order_pos_product.c_sku

wms_rec_product.c_sku

Restrict delete

fkh50mkk9od5jv9uki0agju24e0

wms_rec_order_pos_product.c_order_id

wms_rec_order.c_order_id

Restrict delete

fk_details_ro

wms_rec_order_detail.c_order_pk

wms_rec_order.c_pk

Restrict delete

fk17bn9lck7c22adywer95evhry

wms_rec_order_pos_tu.c_order_id

wms_rec_order.c_order_id

Restrict delete

Check Constraints

Table	Constraint Name	Constraint
wms_rec_order_pos_product	wms_rec_order_pos_product_c_state_check	((c_state)::text = ANY ((ARRAY['CREATED'::character varying, 'PROCESSING'::character varying, 'CANCELED'::character varying, 'PARTIALLY_COMPLETED'::character varying, 'COMPLETED'::character varying])::text[]))
wms_rec_order_pos_tu	wms_rec_order_pos_tu_c_state_check	((c_state)::text = ANY ((ARRAY['CREATED'::character varying, 'PROCESSING'::character varying, 'CANCELED'::character varying, 'PARTIALLY_COMPLETED'::character varying, 'COMPLETED'::character varying])::text[]))
wms_rec_order	wms_rec_order_c_order_state_check	((c_order_state)::text = ANY ((ARRAY['UNDEFINED'::character varying, 'CREATED'::character varying, 'VALIDATED'::character varying, 'PROCESSING'::character varying, 'CANCELED'::character varying, 'PARTIALLY_COMPLETED'::character varying, 'COMPLETED'::character varying])::text[]))