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.
1
1
ABCDE123
johndoe
password
123456
1
1
1
0
0
0
Last updated
Was this helpful?