UserInRegion


Description

User regional assignments linking healthcare staff to specific geographic regions for service delivery and coverage management. This junction table enables regional assignment of staff, supporting geographic service coverage, travel planning, and regional management of healthcare service delivery across different areas.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
userID int 4 √ null
AccessUser.UserID FK__UserInReg__userI__2BCB162A C

User reference - Links to the user account (AccessUser.UserID)
fkRegionID int 4 √ null
Regions.pkRegionID FK__UserInReg__fkReg__2CBF3A63 C

Region reference - Links to the geographic region (Regions.pkRegionID)
regionOrder int 4 √ null

Region order - Priority order for multiple regional assignments

Indexes

Constraint Name Type Sort Column(s)
IX_UserId_fkRegionID Performance Asc/Asc userID + fkRegionID

Relationships

Close relationships within degrees of separation