Sample Header Ad - 728x90

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: enter image description here 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