I'm pretty new to database design.
I have an user table, an user_profile table and an user_address table.
In terms of good pratices. What is the best approach?
User has_one User_profile User has_one User_address User_profile belongs to User User_address belongs to User
User has_one User_profile User_profile has_one User_address User_profile belongs to User User_address belongs to User_profile
My user table stores the data to authentication, the user_profile table the personal infos (first_name, last_name, birth_date, phone...).
I think this is a trivial question, but i'm in doubt what is the best approach.