Constraints

7 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_position_pk
wms_shp_order_position_split.c_position_pk
wms_shp_order_position.c_pk
Restrict delete
fk_shp_pos_split_product
wms_shp_order_position_split.c_product_pk
wms_shp_product.c_pk
Restrict delete
fk_shp_details_product
wms_shp_product_detail.c_product_pk
wms_shp_product.c_pk
Restrict delete
fk_shp_pos_product
wms_shp_order_position.c_product_pk
wms_shp_product.c_pk
Restrict delete
fkqwxs6u3a00ngd8fd3cg7h32kg
wms_shp_order_position.c_order_pk
wms_shp_order.c_pk
Restrict delete
fki2dfcbbxtdi5r8sjruuu5qatr
wms_shp_order_position_tu.c_order_pk
wms_shp_order.c_pk
Restrict delete
fk_position_tu_pk
wms_shp_order_position_tu_split.c_position_pk
wms_shp_order_position_tu.c_pk
Restrict delete

Check Constraints

Table Constraint Name Constraint
wms_shp_order wms_shp_order_c_order_state_check ((c_order_state)::text = ANY ((ARRAY['UNDEFINED'::character varying, 'CREATED'::character varying, 'AVAILABLE'::character varying, 'PROCESSING'::character varying, 'PROCESSED'::character varying, 'COMMISSIONING'::character varying, 'FAILURE_WMS'::character varying, 'FAILURE_TMS'::character varying, 'COMPLETED'::character varying, 'ON_TRUCK'::character varying, 'SHIPPED'::character varying])::text[]))
wms_shp_order wms_shp_order_c_start_mode_check ((c_start_mode)::text = ANY ((ARRAY['AUTOMATIC'::character varying, 'MANUAL'::character varying])::text[]))
wms_shp_order_position_split wms_shp_order_position_split_c_start_mode_check ((c_start_mode)::text = ANY ((ARRAY['AUTOMATIC'::character varying, 'MANUAL'::character varying])::text[]))
wms_shp_order_position wms_shp_order_position_c_order_state_check ((c_order_state)::text = ANY ((ARRAY['UNDEFINED'::character varying, 'CREATED'::character varying, 'AVAILABLE'::character varying, 'PROCESSING'::character varying, 'PROCESSED'::character varying, 'COMMISSIONING'::character varying, 'FAILURE_WMS'::character varying, 'FAILURE_TMS'::character varying, 'COMPLETED'::character varying, 'ON_TRUCK'::character varying, 'SHIPPED'::character varying])::text[]))
wms_shp_order_position wms_shp_order_position_c_to_start_mode_check ((c_to_start_mode)::text = ANY ((ARRAY['AUTOMATIC'::character varying, 'MANUAL'::character varying])::text[]))
wms_shp_order_position_tu wms_shp_order_position_tu_c_order_state_check ((c_order_state)::text = ANY ((ARRAY['UNDEFINED'::character varying, 'CREATED'::character varying, 'AVAILABLE'::character varying, 'PROCESSING'::character varying, 'PROCESSED'::character varying, 'COMMISSIONING'::character varying, 'FAILURE_WMS'::character varying, 'FAILURE_TMS'::character varying, 'COMPLETED'::character varying, 'ON_TRUCK'::character varying, 'SHIPPED'::character varying])::text[]))
wms_shp_order_position_tu wms_shp_order_position_tu_c_to_start_mode_check ((c_to_start_mode)::text = ANY ((ARRAY['AUTOMATIC'::character varying, 'MANUAL'::character varying])::text[]))
wms_shp_order_position_tu_split wms_shp_order_position_tu_split_c_start_mode_check ((c_start_mode)::text = ANY ((ARRAY['AUTOMATIC'::character varying, 'MANUAL'::character varying])::text[]))