MySQL Forums
Forum List  »  Newbie

Database structure
Posted by: lisheridan
Date: August 25, 2004 02:48AM

I'm setting up a database with multiple users. Each user will have their own data and has no need to access the data from other users. For example, each user has a bunch of tasks that they want to track.

user1
weekly tasks
monthly tasks

user2
weekly tasks
monthly tasks

My question is, would it be better to set this up using a separate table per user or a separate database per user? I want to be able to prevent user1 from accessing user2's data!

Also, can any of you recommend a book on creating database strucutres?

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Database structure
August 25, 2004 02:48AM
August 25, 2004 06:46AM
August 27, 2004 11:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.