[thelist] Database wise, how to create groups..

Kristy Frey kristenannfrey at yahoo.com
Thu Mar 21 14:08:00 CST 2002


> Here's what I thought:
> create a table for groups:
> group { groupID, listofpersons }
> where listofpersons is of type varchar(255) and a typical entry would look
> like:
> "2,4,7,11"

Being more of a purist I'd go with this structure for the table where PersonID is a varchar(10) or
number field - that way you dont have to worry if your list gets longer than 255 characters

GroupID    PersonID
-------------------
1           2
1           4
1           7
1           11
2           5
2           31


=====
----------------------------------------------------------
I apologize for the ads/links below - Yahoo put them there.
That's what I get for using free mail
----------------------------------------------------------

__________________________________________________
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/



More information about the thelist mailing list