search

Permission

circle-info

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.

chevron-rightTable Structurehashtag

  • [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.

chevron-rightConstraintshashtag

  • [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.

hashtag
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

...

...

...

...

PreviousRoleNextPlans & Pricing

Last updated