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

ID	Name	Description	Is_System
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