Language


Description

Language definitions and multilingual support managing language options for patients, providers, and system interfaces. This lookup table provides standardized language codes and descriptions for multilingual support, patient language preferences, provider language capabilities, and system localization, supporting diverse patient populations and regulatory compliance for language accessibility.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
LangID int identity 4 √ null
PatientLanguage.fkLangID FK__PatientLanguage__Language C
UserInLanguage.fkLangID FK__UserInLan__fkLan__43A29FBB C

Primary key - Unique identifier for each language
LangDesc varchar 50 √ null

Language description - Full name or description of the language (e.g., ‘English’, ‘Spanish’, ‘Mandarin’)

Indexes

Constraint Name Type Sort Column(s)
PK__Language__79A9AAB1 Primary key Asc LangID

Relationships

Close relationships within degrees of separation