I agree 100% - folk sometimes share emails but also sometimes have to change them e.g. students use Uni email to start but when they leave Uni they lose their Uni email or someone has to change email due to too much spam. All kinds of reasons why email should not be a Primary Key. Really disappointed in this as I am thinking of moving to WA from a provider whose data is badly designed and who also uses email as a key. So easy to use a separate key.
LP
I agree 100% - folk sometimes share emails but also sometimes have to change them e.g. students use Uni email to start but when they leave Uni they lose their Uni email or someone has to change email due to too much spam. All kinds of reasons why email should not be a Primary Key. Really disappointed in this as I am thinking of moving to WA from a provider whose data is badly designed and who also uses email as a key. So easy to use a separate key.