I have a website that has lets say 1000 members, and I have a database that holds membership information in the 'users' table. Each user entry has a unique primary key of id (INT). I need to record click-thru information from users/members, so the way I've done it is to create a new table for each user which contains click info, so user 123 will have an associate 'user_123_clicks' table where click-thru info is stored. This just doesn't feel right to me, I can't join tables as it just isn't relational. What I wanted to avoid is have one enormous 'click' table which would have a foreign key of 'user_id', although this would be more relational I guess?
Which in the best way in your opinion to achieve what I need to, without an enormous click table, but without the contrived 'user_123_clicks' tables?