Organisation Role

This table stores information about individual roles along with document level CRUD permissions. By default 5 roles are given to organisation each time user creates new account. Organisation can add any number of roles according to their need.

Attributes

orgRoleId: Primary key for the role table.

roleName: Name of the role.

orgId: Foreign key of the organisation table. This field stores the information of the Organisation to which role belongs.

permissions: JSON object to stores information about each document level permission.

Associations

Organisation

Custom field always belongs any one organisation.

User

Custom field always created by any one user belongs to organisation.