Patient Address

The patient address table contains normalized address information for patients. This table supports multiple addresses per patient. Primary Keys:

Foreign Keys:

Column	Data Type	Description
patient_id	varchar	Unique identifier for the patient
address	varchar	First and second address lines concatenated
city	varchar	City name
district	varchar	District name (e.g., county)
state	varchar	State or province code
zip_code	varchar	ZIP or postal code
country	varchar	Country code
lines	varchar[]	Address lines as array of strings
data_source_ext	varchar	Integration source of the data, derived from FHIR extension
address_rank	integer	Patient FHIR resource array order

⌘I