patient_address

An address for the individual (Patient.address[]). Previous version: patient_address Primary Keys:

Foreign Keys:

_{† Metriport Platform added}

Column	Data Type	Description
patient_address_id	varchar	Unique identifier for the address row
patient_id	varchar	Parent 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†	array	Address lines (first through fourth lines, nulls removed)
address_rank†	int	Order of this address within the patient (1-based)
data_source_ext†	varchar	Integration source of the data, derived from FHIR extension

Related Tables: Parent:

⌘I