Constraints

2 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

fk_phistory_mvm

mvm_problem_history.c_fk_movement

mvm_movement.c_pk

Restrict delete

fk_mvm_grp

mvm_movement.c_group_pk

mvm_movement_group.c_pk

Restrict delete

Check Constraints

Table	Constraint Name	Constraint
mvm_movement	mvm_movement_c_mode_check	((c_mode)::text = ANY ((ARRAY['AUTOMATIC'::character varying, 'MANUAL'::character varying])::text[]))
mvm_movement	mvm_movement_c_priority_check	((c_priority)::text = ANY ((ARRAY['HIGHEST'::character varying, 'HIGH'::character varying, 'NORMAL'::character varying, 'LOW'::character varying, 'LOWEST'::character varying])::text[]))
mvm_movement	mvm_movement_c_state_check	((c_state)::text = ANY ((ARRAY['INACTIVE'::character varying, 'ACTIVE'::character varying, 'CANCELLED'::character varying, 'DONE'::character varying])::text[]))
mvm_movement	mvm_movement_c_type_check	((c_type)::text = ANY ((ARRAY['UNDEFINED'::character varying, 'MANUAL'::character varying, 'STOCK_CHECK'::character varying, 'INBOUND'::character varying, 'OUTBOUND'::character varying, 'CLEARING'::character varying, 'EMPTIES'::character varying, 'REPLENISHMENT'::character varying, 'RECONCILIATION'::character varying, 'RELOCATION'::character varying, 'WAREHOUSE_RELOCATION'::character varying])::text[]))