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