"FirstName" and "LastName" store in database USER or USER_PROFILE table?

Posted by Khou on Stack Overflow See other posts from Stack Overflow or by Khou
Published on 2010-04-20T04:14:46Z Indexed on 2010/04/20 4:23 UTC
Read the original article Hit count: 280

Currently I store the user's "FirstName" and "LastName" in the USER table, but i also have a USER PROFILE table (which provides additional information about the user) and it would makes sense to have the user's "FirstName" and "LastName" in the USER PROFILE table aswell.

So what do i do? make two copies of "FirstName" and "LastName"?

© Stack Overflow or respective owner

Related posts about database-design

Related posts about sql-server