region
Regions of Vendors.
Primary key: vendor_id, region_id. See the version history of this table on dbdocs.io.
Columns
| Column | Type | Constraints | References | Description |
|---|---|---|---|---|
vendor_id | VARCHAR(255) | PK | vendor.vendor_id | Reference to the Vendor. |
region_id | VARCHAR(255) | PK | Unique identifier, as called at the Vendor. | |
name | VARCHAR(255) | NOT NULL | Human-friendly name. | |
api_reference | VARCHAR(255) | NOT NULL | How this resource is referenced in the vendor API calls. This is usually either the id or name of the resource, depending on the vendor and actual API endpoint. | |
display_name | VARCHAR(255) | NOT NULL | Human-friendly reference (usually the id or name) of the resource. | |
aliases | JSON | NOT NULL | List of other commonly used names for the same Region. | |
country_id | VARCHAR(255) | NOT NULL | country.country_id | Reference to the Country, where the Region is located. |
state | VARCHAR(255) | Optional state/administrative area of the Region''s location within the Country. | ||
city | VARCHAR(255) | Optional city name of the Region''s location. | ||
address_line | VARCHAR(255) | Optional address line of the Region''s location. | ||
zip_code | VARCHAR(255) | Optional ZIP code of the Region''s location. | ||
lon | FLOAT | Longitude coordinate of the Region''s known or approximate location. | ||
lat | FLOAT | Latitude coordinate of the Region''s known or approximate location. | ||
founding_year | INTEGER | 4-digit year when the Region was founded. | ||
green_energy | BOOL | If the Region is 100%% powered by renewable energy. | ||
status | ENUM | NOT NULL | Status of the resource (active or inactive). See Status for the possible values. | |
observed_at | DATETIME | NOT NULL | Timestamp of the last observation. |
Foreign keys
Enums
Status
Last known status of a resource, e.g. active or inactive.
| Value | Description |
|---|---|
ACTIVE | Active and available resource. |
INACTIVE | Unavailable. For Server/Database: temporary or unknown cause. |
PLANNED_FOR_RETIREMENT | Planned for retirement; only valid for Server and Database. |
RETIRED | Not orderable anymore, but prices may still exist (e.g. active multi-year contracts). Only valid for Server and Database. |