Relationship from Orders to Shop and Supplier, or to general User? 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!
Following are my comments:


Users info should be isolated from Other Entities like shop, Supplier etc
Association between User and Shop should be moved to User_Shop table
Association between User and Supplier should be moved to User_Supplier table
There should be association between Shop and Supplier to view the Order from specific Shop by Supplier in the table Shop_Supplier.
There should be a table namely Order_Fulfil to map the orders fulfilled by Suppliers
Not sure about the mapping between the Product and User. Ideally there should be mapping between shop and product and order and Product.