Does anyone havea good DB design for creating and soring email group lists.
Basically I have a contacts table with a structure like
I have several applications and i need to alert several users after different processes execute.
For example, the production group may want to send firstname.lastname@example.org and email@example.com after Production job runs.
QA group may want to send johN@aol.com and firstname.lastname@example.org after QA process runs.
so I am thinking of creating another table for storing Email groups with a list of the people that should receive the emails.
The list can be updated (i.e remove people and add new people).