'Storing Multiple Values (Foreign Key References) in One Column Oracle
I am trying to design a database for a restaurant. I have my restaurant items that make up a restaurant order. One order can contain many items. Within the order I want to reference multiple items (foreign key). Below are sample data from the tables.
Is there a way to store multiple ITEM_ID in the Orders table referencing the Items PK ITEM_ID?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|