Are "FirstName" and "LastName" stored in the USER or USER_PROFILE database?

Question

I currently save the user "FirstName" and "LastName" in the USER table, but I also have the USER PROFILE table (which provides additional information about the user), and it would be wise for the user "FirstName" and "LastName" in the table USER PROFILE.

So what am I doing? make two copies of "FirstName" and "LastName"?

---

The USER table contains the user credentials that the user uses to enter the account control panel, i.e. username, password, registration date, security issues, etc.

The USER_PROFILE table contains information about the user, such as address, phone number, country of birth, country of citizenship, etc.

Relationship

USER 1. * USER_PROFILE

Answer 1

Put the first and last name in the user profile if they are not needed as part of the login procedure. Thus, less data is processed, and they are there more than with account information. Stay with registration data only if they are necessary, and this will speed up the request.

, . , . ( , ), . , , , - .

Answer 2

, 2 . USER, USERPROFILE.

, .

USER USERPROFILE, , . , , , USERPROFILE - , .

Answer 3

USER?

USER_PROFILE USER?

, , .

, .

Answer 4

. , , .

, , , ... USER.

, , .., .

, .

Answer 5

USER USER_PROFILE , ( ), ( , , , ).

You may have a situation where a user profile is mapped to several users (for example, a person has a regular and administrator account). In this case, the name firstname, lastname will be part of the profile.

In addition, if the user has several profiles (for example, a general administrator account), which will also have the name firstname, lastname as part of the profile.