In the application that I want to create I have Buyers and Sellers (these can also be buyers at some point) and the Admin.
Basically I imagine that in the Sign In form users can register as Buyers, they can check the option of becoming also Sellers.
What I do not know how to do, is how to create the database with these users, because the sellers should register the products they have for sale and I suppose that these products should be stored in the database with the name of each vendor. And when the Buyer searches for example (a second-hand iPhone) I would like this search to coincide with the person closest to where he lives.
At the moment in the database I only have the User:
First Name
Last Name
E-mail
Pass
Profile Picture
Address
Postal Code
City
Country
Can someone help me understand how I should have my database based on what I just described? And how should I create the database for products by category?
Thank you