Keep user and user profile in different tables?

Posted by Andrey on Programmers See other posts from Programmers or by Andrey
Published on 2014-05-26T02:06:05Z Indexed on 2014/06/11 3:47 UTC
Read the original article Hit count: 273

Filed under:
|

I have seen in a couple of projects that developers prefer to keep essential user info in one table (email/login, password hash, screen name) and rest of the non essential user profile in another (creation date, country, etc). By non-essential I mean that this data is needed only occasionally. Obvious benefit is that if you are using ORM querying less fields is obviously good. But then you can have two entities mapped to same table and this will save you from querying stuff you don't need (while being more convenient). Does anybody know any other advantage of keeping these things in two tables?

© Programmers or respective owner

Related posts about database

Related posts about database-design