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 |
||||
| result_type_id | numeric | 0 | null |
|
|
The id of the result type |
||||
| result_type | varchar | 128 | √ | null |
|
|
The type of the result |
|||
| result_status | varchar | 32 | √ | null |
|
|
The status of the result |
|||
| description | varchar | 256 | √ | null |
|
|
The description of the result |
|||
| details | text | 2147483647 | √ | null |
|
|
The details of the performed test |
|||
| attestation_time | timestamptz | 35,6 | √ | null |
|
|
The timestamp with the time of the attestation |
|||
| synced_date | timestamptz | 35,6 | √ | CURRENT_TIMESTAMP |
|
|
The timestamp of when this data was last refreshed. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| cocoattestationresult_pk | Primary key | Asc/Asc/Asc | mgm_id + report_id + result_type_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| vn_cocoattestationresult_result_type | (((result_type)::text <> ''::text)) |
| vn_cocoattestationresult_description | (((description)::text <> ''::text)) |
| vn_cocoattestationresult_result_status | (((result_status)::text <> ''::text)) |
Relationships
Close relationships within degrees of separation
