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

php - How can I edit my code to echo the data of child's element where my search term was found in, in XMLReader? -

jQuery Ajax Render Fragments OR Whole Page -

java - Why is BlockingQueue.take() not releasing the thread? -