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)) |