Permission

The Permission table is designed to store permission information for the system. It includes columns for the permission code, name, description, and flags to indicate whether the permission is a system permission. The table also tracks the user who created or last modified the permission, along with the corresponding date and time.

Table Structure

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

• [Code] (varchar(50), nullable): Represents the code of the permission.

• [Name] (nvarchar(500), nullable): Represents the name of the permission.

• [Description] (nvarchar(500), nullable): Represents the description of the permission.

• [Is_System] (bit, not null): Indicates whether the permission is a system permission.

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

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

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

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

Constraints

• [PK_Permission]: Primary key constraint on the [ID] column.

• [DF_Permission_IsSystem]: Default constraint to set [Is_System] to 0 (false) if not specified.

• [DF_Permission_ModifiedDate]: Default constraint to set [Modified_Date] to the current UTC date and time if not specified.

• [DF_Permission_CreatedDate]: Default constraint to set [Created_Date] to the current UTC date and time if not specified.

Example Data

Code	Name	Description	Is_System
BRAND.CREATE	Create Brand	Allows the user to create a new brand.	1
BRAND.VIEW	View Brand	Allows the user to view brand details.	1
BRAND.EDIT	Edit Brand	Allows the user to edit brand details.	1
BRAND.DELETE	Delete Brand	Allows the user to delete a brand.	1
BRAND.DOWNLOAD	Download Brand	Allows the user to download brand details.	1
USER.CREATE	Create User	Allows the user to create a new user.	1
USER.VIEW	View User	Allows the user to view user details.	1
USER.EDIT	Edit User	Allows the user to edit user details.	1
USER.DELETE	Delete User	Allows the user to delete a user.	1
USER.DOWNLOAD	Download User	Allows the user to download user details.	1
...	...	...	...