Role
The Role table is designed to store role information for users. It includes columns for the role name, description, and flags to indicate whether the role is a system role. The table also tracks the user who created or last modified the role, along with the corresponding date and time.
Table Structure
[ID](bigint,auto-incrementing,primary key): Represents the unique identifier for each role record.[Name](nvarchar(250),not null): Represents the name of the role.[Description](nvarchar(500),nullable): Represents the description of the role.[Is_System](bit,not null): Indicates whether the role is a system role.[Modified_By](bigint,nullable): Represents the user who last modified the role.[Modified_Date](datetime,not null): Represents the date and time when the role was last modified.[Created_By](bigint,nullable): Represents the user who created the role.[Created_Date](datetime,not null): Represents the date and time when the role was created.
Constraints
[PK_Role]: Primary key constraint on the[ID]column.[DF_Role_IsSystem]: Default constraint to set[Is_System]to 0 (false) if not specified.[DF_Role_ModifiedDate]: Default constraint to set[Modified_Date]to the current UTC date and time if not specified.[DF_Role_CreatedDate]: Default constraint to set[Created_Date]to the current UTC date and time if not specified.
Example Data
1
Admin
Full access to settings, user management, and system configurations.
1
2
Moderator
Monitors user activity, enforces guidelines, edits, or removes violating content.
1
3
Support
Assists users with issues, provides troubleshooting and solutions.
1
4
Billing
Manages financial transactions, invoicing, payments, and subscriptions.
1
5
IT Staff
Maintains IT infrastructure, hardware, software updates, and security.
1
6
Marketing
Promotes products or services, drives engagement, and achieves business goals.
1
7
Tester
Identifies bugs or improvements through systematic exploration for quality assurance.
1
Last updated