Flexible System for Storing Multiple Email Addresses, with Data About Those Addresses?
I'm creating a contacts database, and I'm not sure how to design it, given what I would like it to do....
1. I would like it to be able to hold unlimited email addresses per person. Some people have 1 address, but some have 5, but I don't want to just create 10 email address fields, and fill them as necessary. That seems clunky to me.
2. I would like to be able to store data about those email addresses. For example, is the email address still valid? Is it a work or personal email address?
My initial instinct is to create a table just for "Email Addresses" and then have an entry for each one, and link them to the record for the people that have them.
But, that seems a bit awkward also.
Is there a more smooth way to do this?
Or is a separate table for the email addresses the best way?
Thanks very much for any guidance you can provide.