PatientLanguage


Description

Patient language preferences managing language associations for patients to support multilingual services and communication needs. This junction table links patients to their preferred languages including display order for multiple languages, supporting multilingual patient care, interpreter services, and culturally appropriate healthcare delivery for diverse patient populations.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fkPatientID int 4 √ null
Patient.PatientID FK__PatientLanguage__Patient C

Patient reference - Links to Patient table for the patient with language preferences (foreign key to Patient.PatientID)
fkLangID int 4 √ null
Language.LangID FK__PatientLanguage__Language C

Language reference - Links to Language table for the preferred language (foreign key to Language.LangID)
displayOrder int 4 √ null

Display order - Numeric order for displaying multiple languages for this patient

Relationships

Close relationships within degrees of separation