Composite foreign keys and deletion actions
Link an item to a bin identified by two numbers. Reject a wrong pair even when both numbers exist, and explicitly choose how parent deletion behaves.
A composite FK checks the complete pair against one parent pair. RESTRICT blocks deleting a referenced parent; CASCADE also deletes children; SET NULL clears the reference and requires nullable columns.