GroupInAction


Description

Group action permissions linking user groups to specific actions and operations for granular access control. This junction table manages group-based permissions for specific actions, operations, and functions within the healthcare system, supporting fine-grained access control and role-based security by defining which actions each user group can perform across different system modules and workflows.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fkGroupID int 4 √ null
UserGroup.GroupID FK_GroupInAction_UserGroup C

Group reference - Links to UserGroup table for the user group receiving action permissions (foreign key to UserGroup.GroupID)
fkActionID int 4 √ null

Action reference - Links to specific action or operation that the group is permitted to perform

Indexes

Constraint Name Type Sort Column(s)
IX_ActionID Performance Asc fkActionID
IX_GroupID Performance Asc fkGroupID

Relationships

Close relationships within degrees of separation