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 email@example.com and firstname.lastname@example.org after Production job runs.
QA group may want to send johN@aol.com and email@example.com 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).