Roles


Description

User roles and permissions defining role-based access control and permission sets for healthcare system users. This table manages role definitions, descriptions, locking status, and discipline type associations to support comprehensive role-based security, user management, and access control for healthcare applications and organizational structure management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
RoleId uniqueidentifier 16 (newid())

Primary key - Unique identifier for each role (GUID format)
RoleName nvarchar 400 √ null

Role name - Descriptive name of the role (e.g., ‘Provider’, ‘Service Coordinator’, ‘Administrator’)
RoleDesc nvarchar 1000 √ null

Role description - Detailed description of the role’s responsibilities and permissions
isLocked bit 1 √ null

Lock status - Boolean indicating if the role is locked from modification
DisTypeID int 4 √ null

Discipline type reference - Links to discipline type associated with this role

Indexes

Constraint Name Type Sort Column(s)
PK__Role__8AFACE1A1F3FE61D Primary key Asc RoleId

Relationships

Close relationships within degrees of separation