UserInCustomConfig


Description

User custom configuration assignments linking users to personalized configuration settings and interface customizations. This junction table enables user-specific configuration of system behavior, interface layouts, and feature settings, supporting personalized user experiences and workflow optimization for healthcare staff.

Columns

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

Primary key - Unique identifier for each user configuration assignment
fkUserID int 4 √ null
AccessUser.UserID FK__UserInCustomConfig__Accessuser C

User reference - Links to the user account (AccessUser.UserID)
fkconfigID int 4 √ null
CustomConfig.configID FK__UserInCustomConfig__CustomConfig C

Configuration reference - Links to the custom configuration (CustomConfig.configID)
DisplayOrder int 4 √ null

Display order - Order in which configurations are applied or displayed

Indexes

Constraint Name Type Sort Column(s)
PK_UserInCustomConfig Primary key Asc pkUserConfig

Relationships

Close relationships within degrees of separation