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 |
||||||
| scan_id | numeric | 131089 | null |
|
|
The id of the security scan |
||||||
| rule_id | numeric | 131089 | null |
|
|
The id of the rule |
||||||
| idref | varchar | 255 | √ | null |
|
|
The reference of the rule |
|||||
| rulesystem | varchar | 80 | √ | null |
|
|
The name of the rule system |
|||||
| system_id | numeric | 131089 | null |
|
|
The id of the system |
||||||
| ident | varchar | 255 | √ | null |
|
|
The CCE v5 id of this rule |
|||||
| result | varchar | 16 | √ | null |
|
|
The result of the scan for this rule |
|||||
| synced_date | timestamptz | 35,6 | √ | CURRENT_TIMESTAMP |
|
|
The timestamp of when this data was last refreshed. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| xccdscanresult_pk | Primary key | Asc/Asc/Asc | mgm_id + scan_id + rule_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| vn_xccdscanresult_ident | (((ident)::text <> ''::text)) |
| vn_xccdscanresult_rulesystem | (((rulesystem)::text <> ''::text)) |
| vn_xccdscanresult_idref | (((idref)::text <> ''::text)) |
| vn_xccdscanresult_result | (((result)::text <> ''::text)) |
Relationships
Close relationships within degrees of separation
