vendor
Compute resource vendors, such as cloud and server providers.
Primary key: vendor_id. See the version history of this table on dbdocs.io.
Columns
| Column | Type | Constraints | References | Description |
|---|---|---|---|---|
vendor_id | VARCHAR(255) | PK | Unique identifier. | |
name | VARCHAR(255) | NOT NULL | Human-friendly name. | |
logo | VARCHAR(255) | Publicly accessible URL to the image of the Vendor''s logo. | ||
homepage | VARCHAR(255) | Public homepage of the Vendor. | ||
country_id | VARCHAR(255) | NOT NULL | country.country_id | Reference to the Country, where the Vendor''s main headquarter is located. |
state | VARCHAR(255) | Optional state/administrative area of the Vendor''s location within the Country. | ||
city | VARCHAR(255) | Optional city name of the Vendor''s main location. | ||
address_line | VARCHAR(255) | Optional address line of the Vendor''s main location. | ||
zip_code | VARCHAR(255) | Optional ZIP code of the Vendor''s main location. | ||
founding_year | INTEGER | NOT NULL | 4-digit year when the public cloud service of the Vendor was launched. | |
status_page | VARCHAR(255) | Public status page of the Vendor. | ||
stopped_server_charged | BOOL | If the Vendor charges for stopped servers. In case it depends on the instance type or different versions of stopped states, this field reports the worst case. | ||
billing_increment_seconds | INTEGER | The smallest increment of time for which the Vendor bills for. | ||
minimum_billing_seconds | INTEGER | The minimum amount of time for which the Vendor bills for. In case it depends on the instance type or other context, this field reports the worst case. | ||
billing_comment | VARCHAR(255) | Comment on the Vendor''s billing. | ||
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
country_id→country(country_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. |