Last updated
Was this helpful?
Last updated
Was this helpful?
The UserProfile table is used to store user profile information in the system. It includes columns for the user ID, first name, last name, nickname, avatar, email address, phone numbers, website, description, and timestamps for modification and creation.
[ID] (bigint): Primary key column with auto-incrementing values.
[User_ID] (bigint): Foreign key column referencing the [ID] column of the [JFW].[User] table.
[First_Name] (nvarchar(50), nullable): Represents the user's first name.
[Last_Name] (nvarchar(50), nullable): Represents the user's last name.
[Nick_Name] (nvarchar(50), nullable): Represents the user's nickname.
[Avatar] (nvarchar(500), nullable): Represents the URL of the user's avatar.
[Email_Address] (varchar(150), nullable): Represents the user's email address.
[PhoneNumber1] (varchar(20), nullable): Represents the user's primary phone number.
[PhoneNumber2] (varchar(20), nullable): Represents an additional phone number.
[PhoneNumber3] (varchar(20), nullable): Represents another additional phone number.
[Website] (nvarchar(200), nullable): Represents the user's website URL.
[Description] (nvarchar(max), nullable): Represents a description of the user.
[Modified_By] (bigint): Represents the ID of the user who last modified the profile.
[Modified_Date] (datetime): Represents the timestamp of the last modification.
[Created_By] (bigint): Represents the ID of the user who created the profile.
[Created_Date] (datetime): Represents the timestamp of the creation.
[PK_UserProfile]: Primary key constraint on the [ID] column.
[DF_UserProfile_ModifiedDate]: Default constraint to set the [Modified_Date] column to the current UTC date and time.
[DF_UserProfile_CreatedDate]: Default constraint to set the [Created_Date] column to the current UTC date and time.
[FK_UserProfile_User]: Foreign key constraint on the [User_ID] column, referencing the [JFW].[User].[ID] column.
The Email_Address is encrypted in database, but for the sake of example, it is shown in plain text here.
1
John
Doe
JD
URL
john.doe@gmail.com
1234567890
0987654321
5432167890
URL
I'm a developer