database_storage
Managed database storage products.
Primary key: vendor_id, database_storage_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. |
database_storage_id | VARCHAR(255) | PK | Unique identifier, as called at the Vendor. | |
name | VARCHAR(255) | NOT NULL | Human-friendly name. | |
description | VARCHAR(255) | Short description. | ||
scope | ENUM | NOT NULL | Scope of the storage product, e.g. data or backup. See DatabaseStorageScope for the possible values. | |
redundancy | VARCHAR(255) | Redundancy model, e.g. LRS or GRS. | ||
min_size | INTEGER | Minimum required size (GB). | ||
max_size | INTEGER | Maximum possible size (GB). | ||
max_iops | INTEGER | Maximum Input/Output Operations Per Second. | ||
max_throughput | INTEGER | Maximum Throughput (MB/s). | ||
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→vendor(vendor_id)
Enums
DatabaseStorageScope
Scope of a managed database storage product.
| Value | Description |
|---|---|
DATA | Primary database data storage. |
BACKUP | Backup or archive storage. |
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. |