[MESDK-178](https://linear.app/opral/issue/MESDK-178/implement-foreign-key-constraints) requires us to raise conflicts if foreign keys are violated.