designing table relations?

[Jett]

HI

how to design my table relations correctly?

I have few tables with user preferences and I'd like to create table 'events' which will store events that are happening in the certain time. Table has to store information what kind of event it is. Does anyone have an idea how to do it so its nice and fast.

I wana create a big table with columns for everything and just storing the ids for everything that you can be interested.
Thanks for help -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Saggie]

you should put all of your preference information into a single table rather than creating a new table for each category.
Also, having a column per category gives you the same issues as a table per category, the schema has to change each time you add a new category.
For table of category names and IDs, add rows to the preferences table per category per user, so each row in the preferences table has a userid, a categoryid, and a specific preference. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --