
August 27th, 2003, 02:37 PM
|
|
Average Intelligence
|
|
Join Date: Apr 2003
Location: Ohio/Chicago
Posts: 678
Time spent in forums: 10 m 22 sec
Reputation Power: 6
|
|
|
how's this contact list schema sound
we have 5 emails, each with a different to from and cc list. I was thinking about making the database with user id, and then a column for each email where it's either 1 or 0 for if they get it. But then the script will have to query the database a lot of times. i was also thinking about having a list of users, and then a separate table for each email with the column in each table being the user id and just dong a join for each email and then it'd be easier from a db perspective.... I'm not sure, can't really think of which way is the best way or of a better way than these...any sugguestions?
|