Table Type: Metadata
This table contains locations. Locations are used to determine how calls to emergency services are routed, and can also be used to determine where users are.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| id | string | Primary Key | The unique identifier of the location. |
| db_last_updated | datetime | When this record was last updated in UTC. | |
| db_when_created | datetime | When this record was created in UTC. | |
| db_when_deleted | datetime | When this record was deleted in UTC or NULL. | |
| state | string | active or deleted | |
| name | string | The name of the location. | |
| contact_user_id | string | The user id of the contact person for the location. | |
| emergency_number_type | string | One of: default or elin | |
| emergency_number_e164 | string | The emergency number in E.164 format. | |
| emergency_number_number | string | The emergency number that people in the location must dial. | |
| address_city | string | The city of the location. | |
| address_country | string | The country code of the location. | |
| address_country_name | string | The full name of the country of the location. | |
| address_state | string | The state or province of the location. | |
| address_street1 | string | The first line of the street address of the location. | |
| address_street2 | string | The second line of the street address of the location. | |
| zipcode | string | The postal code of the location. | |
| notes | string | Additional notes about the location. | |
| address_verified | boolean | Whether the address has been verified as an actual address. | |
| address_stored | boolean | Whether the address is stored for emergency services. |