Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| mgm_id | numeric | 131089 | √ | null |
|
|
The id of the SUSE Manager instance that contains this data |
|
| errata_id | numeric | 131089 | √ | null |
|
|
The id of the patch |
|
| advisory_name | varchar | 100 | √ | null |
|
|
The unique name of the advisory |
|
| advisory_type | varchar | 32 | √ | null |
|
|
The type of patch. Possible values: Product Enhancement Advisory, Security Advisory, Bug Fix Advisory |
|
| cve | varchar | 4000 | √ | null |
|
|
A list of CVE ids that this patch addresses, separated by ; |
|
| synopsis | varchar | 4000 | √ | null |
|
|
The brief description of this patch |
|
| issue_date | timestamptz | 35,6 | √ | null |
|
|
When this advisory was first issued |
|
| update_date | timestamptz | 35,6 | √ | null |
|
|
When this advisory was last updated |
|
| affected_systems | int8 | 19 | √ | null |
|
|
The number of system affected by this advisory |
|
| synced_date | timestamptz | 35,6 | √ | null |
|
|
The timestamp of when this data was last refreshed. |
Relationships
Close relationships within degrees of separation
