Skip to main content
The patient name table contains normalized name information for patients. This table supports multiple names per patient, allowing for historical name tracking, legal name changes, and aliases. Primary Keys:
  • patient_id
  • name_rank
Foreign Keys:
  • patient_id - links to the patient table
ColumnData TypeDescription
patient_idvarcharUnique identifier for the patient
last_namevarcharFamily name (last name)
first_namevarcharFirst given name
given_namesvarchar[]All given names for the family name as array of strings
suffixesvarchar[]Name suffixes as array of strings
prefixesvarchar[]Name prefixes as array of strings
data_source_extvarcharSource of the name data
name_rankintegerPatient FHIR resource array order