User

The User table is used to store user information in the system. It includes columns for the user ID, parent user ID, brand ID, user code, username, password, passphrase, user type, email address verification status, user verification status, system status, risk mark, status, and the user who created or last modified the record, along with the corresponding date and time.

Table Structure

• [ID] (bigint, auto-incrementing, primary key): Represents the unique identifier for each user record.

• [Parent_User_ID] (bigint, nullable): Represents the parent user associated with the user.

• [Brand_ID] (bigint, not null): Represents the brand associated with the user.

• [User_Code] (varchar(100), not null): Represents the user code.

• [Username] (varchar(150), not null): Represents the username.

• [Password] (varchar(150), not null): Represents the password.

• [Passphrase] (varchar(6), nullable): Represents the passphrase.

• [User_Type] (smallint, nullable): Represents the user type.

• [Is_Email_Address_Verified] (bit, nullable): Represents the email address verification status.

• [Is_User_Verified] (bit, nullable): Represents the user verification status.

• [Is_System] (bit, not null): Represents the system status.

• [Risk_Mark] (tinyint, nullable): Represents the risk mark.

• [Status] (smallint, not null): Represents the status.

• [Modified_By] (bigint, nullable): Represents the user who last modified the record.

• [Modified_Date] (datetime, not null): Represents the date and time when the record was last modified.

• [Created_By] (bigint, nullable): Represents the user who created the record.

• [Created_Date] (datetime, not null): Represents the date and time when the record was created.

Constraints

• [PK_User]: Primary key constraint on the [ID] column

• [UK_User_UserCode]: Unique constraint on the [User_Code] column

• [UK_User_Username]: Unique constraint on the [Brand_ID] and [Username] columns

• [DF_User_UserType]: Default constraint on [User_Type] column with default value 1

• [DF_User_IsEmailAddressVerified]: Default constraint on [Is_Email_Address_Verified] column with default value 0

• [DF_User_IsUserVerified]: Default constraint on [Is_User_Verified] column with default value 0

• [DF_User_IsSystem]: Default constraint on [Is_System] column with default value 0

• [DF_User_RiskMark]: Default constraint on [Risk_Mark] column with default value 0

• [DF_User_Status]: Default constraint on [Status] column with default value 0

• [DF_User_ModifiedDate]: Default constraint on [Modified_Date] column with default value of the current UTC date and time

• [DF_User_CreatedDate]: Default constraint on [Created_Date] column with default value of the current UTC date and time

Example Data

The Username and Password field data are for illustrative purposes only and do not represent actual user data. The real data will be encrypted and stored securely in the database.

Parent_User_ID	Brand_ID	User_Code	Username	Password	Passphrase	User_Type	Is_Email_Address_Verified	Is_User_Verified	Is_System	Risk_Mark	Status
1	1	ABCDE123	johndoe	password	123456	1	1	1	0	0	0