vendor_compliance_link
List of known Compliance Frameworks paired with vendors.
Primary key: vendor_id, compliance_framework_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. |
compliance_framework_id | VARCHAR(255) | PK | compliance_framework.compliance_framework_id | Reference to the Compliance Framework. |
comment | VARCHAR(255) | Optional references, such as dates, URLs, and additional information/evidence. | ||
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)compliance_framework_id→compliance_framework(compliance_framework_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. |