UserInLanguage


Description

User language proficiency tracking languages spoken by healthcare staff for patient communication and service delivery. This junction table enables matching of multilingual staff with patients who speak specific languages, supporting culturally appropriate care and effective communication in diverse healthcare environments.

Columns

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

User reference - Links to the user account (AccessUser.UserID)
fkLangID int 4 √ null
Language.LangID FK__UserInLan__fkLan__43A29FBB C

Language reference - Links to the language (Language.LangID)
displayOrder int 4 √ null

Display order - Order of language proficiency or preference for the user

Indexes

Constraint Name Type Sort Column(s)
IX_fkUserID_fkLangID Performance Asc/Asc fkUserID + fkLangID

Relationships

Close relationships within degrees of separation