GroupApps


Description

Group application access - Junction table managing application access permissions for user groups including settings and beta testing privileges. This table controls group-based access to applications, feature settings, and beta testing programs to support role-based application access, feature rollouts, and testing coordination for healthcare system applications.

Columns

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

Group app primary key - Unique identifier for each group-application relationship
fkAppID int 4 null

Application reference - Links to Apps table for the application
fkGroupID int 4 null

Group reference - Links to Groups table for the user group
IsSetting bit 1 ((0))

Settings access flag - Indicates if the group has access to application settings
isBetaTeam bit 1 ((0))

Beta team flag - Indicates if the group is part of the beta testing team

Indexes

Constraint Name Type Sort Column(s)
PK__GroupApp__E81661FB18DD0151 Primary key Asc pkGroupAppID

Relationships

Close relationships within degrees of separation