I'm trying to normalize a table to best hold the following data:
username, group1, group2, group3, group4... groupN...
there are 1000s of unique usernames, and 10000s of unique groups
every user can subscribe to 1-10000 diffrent groups (so I don't know how much group
colums to put).
I need somehow to maintain a list of subscribed groups for each user.
is there a better way then 2 fields like the following:
username (nvarchar(30)
groups (longtext) = > group1,group3,group15,group7,group9 ?
Thanks,
-=Michael.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
