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  | 
                                |
| system_id | numeric | 0 | √ | null | 
                                         | 
                                    
                                         | 
                                    The id of the system  | 
                                |
| hostname | varchar | 128 | √ | null | 
                                         | 
                                    
                                         | 
                                    The hostname that identifies this system  | 
                                |
| organization | varchar | 128 | √ | null | 
                                         | 
                                    
                                         | 
                                    The organization that owns this data  | 
                                |
| environment_type | varchar | 120 | √ | null | 
                                         | 
                                    
                                         | 
                                    The type of the environment of the attested system  | 
                                |
| result_type | varchar | 128 | √ | null | 
                                         | 
                                    
                                         | 
                                    The type of the result  | 
                                |
| result_status | varchar | 32 | √ | null | 
                                         | 
                                    
                                         | 
                                    The status of the result  | 
                                |
| description | varchar | 256 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||
| attestation_time | timestamptz | 35,6 | √ | null | 
                                         | 
                                    
                                         | 
                                    The timestamp when this result was attested  | 
                                |
| synced_date | timestamptz | 35,6 | √ | null | 
                                         | 
                                    
                                         | 
                                    The timestamp of when this data was last refreshed.  | 
                                
