I'm putting together my own mailing list manager (built in PHP and mySQL) and I have a question on managing users.
My thoughts were to have two DB tables: 1. emails table and 2. Lists table.
The link would be that each user in the 'emails' table would have a key to the 'Lists' table. That work fine.
The main downfall of this simple system is that there is a direct 1 to 1 relationship between a user and a list.
What I am now thinking is how do I get a user to be on more than one list?
Is there a better design?
My thoughts were to have two DB tables: 1. emails table and 2. Lists table.
The link would be that each user in the 'emails' table would have a key to the 'Lists' table. That work fine.
The main downfall of this simple system is that there is a direct 1 to 1 relationship between a user and a list.
What I am now thinking is how do I get a user to be on more than one list?
Is there a better design?