Relationship from Orders to Shop and Supplier, or to general User?
1
vote
2
answers
1709
views
I have a platform where
- a User can have a Shop, which can place Orders
- a User can be a Supplier, which can see Orders from Shops coming in.
I have created the following diagram depicting the structure I have modeled so far:
Is that a *good* schema? Or, would it make more sense to *couple* the relationships to the User straight away?
I'm guessing that will cause more overhead in my backend? (Laravel - PHP)
Thank you!

Asked by Miguel Stevens
(169 rep)
May 9, 2017, 02:32 PM
Last activity: Aug 10, 2025, 09:08 AM
Last activity: Aug 10, 2025, 09:08 AM