Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| mgm_id | numeric | 0 | null |
|
|
The id of the SUSE Multi-Linux Manager instance that contains this data |
||||||
| report_id | numeric | 0 | null |
|
|
The id of the report |
||||||
| system_id | numeric | 0 | null |
|
|
The id of the system |
||||||
| action_id | numeric | 0 | null |
|
|
The id of the action that triggered the attestation |
||||||
| environment_type | varchar | 120 | √ | null |
|
|
The type of the environment of the attested system |
|||||
| status | varchar | 32 | √ | null |
|
|
The status of the attestation |
|||||
| create_time | timestamptz | 35,6 | √ | null |
|
|
The timestamp when the attestation was started |
|||||
| pass | numeric | 0 | √ | null |
|
|
The number of passed attestation results |
|||||
| fail | numeric | 0 | √ | null |
|
|
The number of failed attestation results |
|||||
| synced_date | timestamptz | 35,6 | √ | CURRENT_TIMESTAMP |
|
|
The timestamp of when this data was last refreshed. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| cocoattestation_pk | Primary key | Asc/Asc | mgm_id + report_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| vn_cocoattestation_status | (((status)::text <> ''::text)) |
| vn_cocoattestation_environment_type | (((environment_type)::text <> ''::text)) |

