I am creating a site where users can sell their products(let say a little version of eBay, just assumption). Concerning the database design am a little bit stuck and looking for some ideas how it is done in real world.
My initial thoughts
I wanted to create one database for each user (seller). But I realize that if let say 70,000 people (70,000 is just assumption) want to sell, then 70,000 databases must be created. I think this may not the right idea. Or?
I am also thinking of creating one database for all sellers. I don't know if it is the best thing to do.
My question is what is the best way of designing a database for the above purpose?
Sites like eBay, how do they design their database for such large people to sell? Do they use one database, or each user has his own database?
I have googled "eBay database design" but the results i got were not what i was looking for. The results were too high level(not how they designed their database).
Is it advisable to create for each user a sub-domain?
A pointer to where I can find how such systems are designed will be appreciated.
I hope someone can help me with some specific answers. Thank you