GroupAddons


Description

Group addon associations linking user groups to addon features and extensions for enhanced functionality access. This junction table manages group-based access to addon features, extensions, and enhanced functionality modules, supporting role-based feature access control and addon management for different user groups within the healthcare system to enable customized functionality based on group permissions and organizational needs.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkGroupAddonID int identity 4 √ null

Primary key - Unique identifier for each group-addon association record
fkGroupID int 4 √ null
UserGroup.GroupID FK_GroupAddons_UserGroup R

Group reference - Links to UserGroup table for the user group receiving addon access (foreign key to UserGroup.GroupID)
fkAddonID int 4 √ null

Addon reference - Links to addon or feature module being granted to the group
AddonType nvarchar 20 √ null

Addon type classification - Category or type of addon being associated with the group (e.g., ‘Feature’, ‘Module’, ‘Extension’)

Relationships

Close relationships within degrees of separation