How to properly structure multiple user types?
0
votes
1
answer
358
views
So i'm building a database for an app/website. It's essentially a e-commerce marketplace/platform where a brand can sign up to upload their products and customers can also then sign up to purchase any products from any various brands.
A brand and or employee cannot be a customer
A customer cannot be a brand
This is the structure I have so far, but it seems to me that from this diagram it implies that a user can be a customer, brand and brand employee at the same time.
Is there a better optimal structure for this?

Asked by user210359
(1 rep)
Jun 17, 2020, 08:36 AM
Last activity: Sep 5, 2025, 08:05 PM
Last activity: Sep 5, 2025, 08:05 PM