Quick DB Design

2001-05-06 Thread Michael Lugassy
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 1s of unique groups every user can subscribe to 1-1 diffrent groups (so I don't know how much group colums to put). I need

RE: Quick DB Design

2001-05-06 Thread David Shadovitz
Aack! This is a classic many-to-many relationship, best represented by 3 tables: Table Users (userid, username, other user info) Table Groups (groupid, groupname, other group info) Table UsersGroups (userid, groupid) -David On Sunday, May 06, 2001 9:38 AM, Michael Lugassy [SMTP:[EMAIL

RE: Quick DB Design

2001-05-06 Thread Raymond B.
by SELECT count(uid) AS cnt WHERE gid = var GROUP BY gid, etc. If that data was stored in a list in a field, it would negate the purpose of storing it in a database. -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: May 6, 2001 09:38 To: CF-Talk Subject: Quick DB

Re: Quick DB Design

2001-05-06 Thread Bryan LaPlante
06, 2001 11:38 AM Subject: Quick DB Design 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 1s of unique groups every user can subscribe to 1-1 diffrent groups (so I don't

Re: Quick DB Design

2001-05-06 Thread Tony Schreiber
users - user information groups - group information usergroups - userid, groupid For every group that a user belongs to, there should be an entry in the usergroups table with their userid and the groupid I'm trying to normalize a table to best hold the following data: username, group1,

RE: Quick DB Design

2001-05-06 Thread Kelly Matthews
This is the way I would go too: -Kelly This is a classic many-to-many relationship, best represented by 3 tables: Table Users (userid, username, other user info) Table Groups (groupid, groupname, other group info) Table UsersGroups (userid, groupid) -David On Sunday, May 06, 2001 9:38 AM,

Re: Quick DB Design

2001-05-06 Thread mahmad
I want to unsubscribe from CFtalk. What should i do? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/

Re: Quick DB Design

2001-05-06 Thread Michael Kear
read 4 lines below where you've ever ready before. I'ts sent to you hundreds of times a day. Cheers, Mike kear On Mon, 7 May 2001 [EMAIL PROTECTED] wrote: I want to unsubscribe from CFtalk. What should i do? ~~ Structure your ColdFusion