storage
Flexible storage options that can be attached to a Server.
Primary key: vendor_id, 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. |
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. | ||
storage_type | ENUM | NOT NULL | High-level category of the storage, e.g. HDD or SDD. See StorageType for the possible values. | |
max_iops | INTEGER | Maximum Input/Output Operations Per Second. | ||
max_throughput | INTEGER | Maximum Throughput (MB/s). | ||
min_size | INTEGER | Minimum required size (GB). | ||
max_size | INTEGER | Maximum possible size (GB). | ||
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
StorageType
Type of a storage, e.g. HDD or SSD.
| Value | Description |
|---|---|
HDD | Magnetic hard disk drive. |
SSD | Solid-state drive. |
NVME_SSD | NVMe based solid-state drive. |
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. |