Patient.address[]).
Previous version: patient_address
Primary Keys:
- patient_address_id
- patient_id - links to the patient table
† 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 |