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

