PDA

View Full Version : Webapp Database Structure



lwhite
03 Jun 2011, 08:56 AM
I am constructing a task management application and need some advice on how to structure my databases & tables. I have a few different options in mind, but am looking for the most proper, efficient solution:

1. The application allows each user to store a personal (private) to-do list. Should everyone’s tasks be stored in one table, or should each user have their own table with their own task items?

2. Similar to the above question: If users in an online store had the ability to create a list of personal “favorites”... I understand it would be a simple relational database, but should all the relationships for all the users & products reside in one table? Or should each user, once again, have their own table for their own favorites?

Any advice on this matter would be greatly appreciated!
Thanks,
Logan