在MySQL中构建用户数据[关闭]

Question

I'm setting up a new web service, and need some help with organizing the data in my application. My application's written in PHP, and I plan to store all user data in using MySQL Databases.

I will have a bunch of users, and each of those users will have a bunch of data that is tied to their account. It's a note taking application, and so, naturally, for every user, I need to keep track of the number of notes, and the content of each of those notes.

How do I go about structuring this and translating this into MySQL tables? I know I have to do something that revolves around linked (related) tables, but can't seem to pinpoint it.

I have 10x1GB databases.

Answer 1

Have the following tables (you can choose your own names);

tbl_users
int(4)       userid (PRIMARY)
varchar(128) firstname
varchar(128) lastname

tbl_notes
int(8)       noteid (PRIMARY)
int(4)       userid
text         notecontent

As you can see, userid is the relation between the two tables (1 to many in this case).

See Database normalization from Wikipedia