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
database
|database-design
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