How to design this simple database?
Posted
by Vafello
on Stack Overflow
See other posts from Stack Overflow
or by Vafello
Published on 2010-04-21T12:36:46Z
Indexed on
2010/04/21
12:53 UTC
Read the original article
Hit count: 246
I have 2 tables - one storing user information (id, username, password) and the second one storing information about events (id, name, description, date, username(represents the user who created the event)). I would like to implement 'favourite events' functionality. This would allow the user to store his favourite events and later display them in a list. I am not sure how to implement this in terms of design. I need a simple solution. Something like storing the IDs of favourite events in a field in the user table. I am using mysql and php. Can anyone point me to the right direction?
© Stack Overflow or respective owner