sql server 2005 - Having a Login ID and a PersonID in SQL -


i creating application require user register , create account.

should use person's login id (this email address) unique record identifier or should create personid (or rec_id).

why should (or should not) create rec_id ?

if use email address primary key in person table , foreign key in related tables, it hard implement change email feature - instead of single update, forced add new record person, update related records , delete record old email.


Comments

Popular posts from this blog

javascript - Iterate over array and calculate average values of array-parts -

iphone - Using nested NSDictionary with Picker -

objective c - Newbie question -multiple parameters -