I am keeping this as short as I can. I am building a site where the user saves "notes"
Notes are purely text and the user should be able to make multiple notes under different name.
I have no idea how I am going to arrange this into a table 0_0
Like should my table columns be like this
Username | Password | IDno. | Notes |
And stuff all of the user's notes into a single column..? I am confus >.<
Or should I just separate the IDno. column and Notes into
btw I really need IDno. column as the site isn't going to represent users by their username, just their ID no.
Thanks in advance.
- user_id: pk
- note_id: pk
- user_id: fk (what user posted the note)
You might want to read up on relational databases, and on normalization.