PERMISSION

Description

This table stores permissions.

Columns

Column Name Data Type Description
ID bigint The unique identifier of the permission.
INTERNAL bit Indicates if the permission is internal.
INTERNAL_NAME varchar The internal name of the permission.
NAME varchar The name of the permission.
PERMISSION_GROUP bigint The foreign key referencing the ID column of the PERMISSION_GROUP table.

Constraints

  • UNIQUE KEY UKln36hcm6fb26p7n2yf70lku2y (INTERNAL_NAME)
  • UNIQUE KEY UKsea0n4mglmpe49qqrc00ggev (NAME)

Foreign Key Relationships

  • PERMISSION_GROUP references PERMISSION_GROUP (ID)