Re: MySQL Structure - Order Portal
Would it be best to have another table say "Products Allowed" and put 2 FK restraints CustomerID and ProductID? The only problem is that it's duplicating data. Like below:
+------------+-----------+--+--+--+
| CustomerID | ProductID | | | |
+------------+-----------+--+--+--+
| 1 | 25 | | | |
+------------+-----------+--+--+--+
| 1 | 43 | | | |
+------------+-----------+--+--+--+
| 1 | 56 | | | |
+------------+-----------+--+--+--+
Subject
Written By
Posted
Re: MySQL Structure - Order Portal
July 14, 2016 12:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.