Re: Database design questions

2004-07-22 Thread SGreen
Big post = long response. Thank you for your patience. When it comes to DB design I like to first identify the basic objects: List owners (the people who manage a group), subscribers (the people in the group), and the groups themselves. I think you equate a list owner to a "User" of your servic

Database design questions

2004-07-21 Thread Scott Haneda
I am stuck on how to design a set of tables. I hope someone can help me. I am using mysql 4.0.18-standard. A little background, this is a mailing list manager, it support multiple account holders. User_id is the account holders id, this is unique auto inc and carried across all table to make su