UserInSite


Description

User site assignments linking users to specific service delivery sites within programs. This junction table establishes which sites users are authorized to work at, supporting site-based access control, scheduling, and service delivery management across multiple locations within healthcare programs.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SPID int 4 √ null
SiteInProgramType.SPID FK__UserInSite__SPID__13D2C5B1 C

Site program reference - Links to the site-program combination (SiteInProgramType.SPID)
UserID int 4 √ null
AccessUser.UserID FK__UserInSit__UserI__14C6E9EA C

User reference - Links to the user account (AccessUser.UserID)

Indexes

Constraint Name Type Sort Column(s)
IX_Spid Performance Asc SPID
IX_UserID Performance Asc UserID

Relationships

Close relationships within degrees of separation