Practitioner.address[]).
Primary Keys:
- practitioner_address_id
- practitioner_id - links to the practitioner table
† Metriport Platform added
| Column | Data Type | Description |
|---|---|---|
| practitioner_address_id | varchar | Unique identifier for the address row |
| practitioner_id | varchar | Parent practitioner |
| 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 practitioner (1-based) |