zone

Availability zones of Regions.

Primary key: vendor_id, region_id, zone_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	region.region_id	Reference to the Region.
zone_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.
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

• vendor_id, region_id → region (vendor_id, region_id)
• vendor_id → vendor (vendor_id)

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.

Referenced by

• server_price