UserInGroupClient


Description

User group client associations linking users to client groups for access control and data filtering. This junction table establishes which client groups users have access to, supporting multi-tenant data isolation, client-specific access control, and group-based data filtering for healthcare organizations serving multiple client populations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
UserId int 4 null
AccessUser.UserID FK_UserInGroupClient_AccessUser R

User reference - Links to the user account (AccessUser.UserID)
GroupId int 4 null
Groups.GroupId FK_UserInGroupClient_Groups R

Group reference - Links to the client group (Groups.GroupId)
Id int identity 4 √ null

Primary key - Unique identifier for each user-group association

Indexes

Constraint Name Type Sort Column(s)
PK_UserInGroupClient Primary key Asc Id
IX_UserId Performance Asc UserId
IX_UserId_GroupId Performance Asc/Asc UserId + GroupId

Relationships

Close relationships within degrees of separation