Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| mgm_id | numeric | 131089 | null |
|
|
The id of the SUSE Manager instance that contains this data |
||||
| instance_id | numeric | 131089 | null |
|
|
The id of the virtual system instance |
||||
| host_system_id | numeric | 131089 | √ | null |
|
|
The id of the host system, if available |
|||
| virtual_system_id | numeric | 131089 | √ | null |
|
|
The id of the virtual system, if available |
|||
| name | varchar | 128 | √ | null |
|
|
The name of this virtual system |
|||
| instance_type_name | varchar | 128 | √ | null |
|
|
The type of virtualization |
|||
| vcpus | numeric | 131089 | √ | null |
|
|
The number of virtual CPUs |
|||
| memory_size | numeric | 131089 | √ | null |
|
|
The available memory in megabytes |
|||
| uuid | varchar | 128 | √ | null |
|
|
The universally unique identifier of this virtual instance |
|||
| confirmed | numeric | 1 | √ | null |
|
|
1 if this virtual instance is confirmed |
|||
| state_name | varchar | 128 | √ | null |
|
|
The current state of this virtual instance |
|||
| synced_date | timestamptz | 35,6 | √ | CURRENT_TIMESTAMP |
|
|
The timestamp of when this data was last refreshed. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| systemvirtualdata_pk | Primary key | Asc/Asc | mgm_id + instance_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| vn_systemvirtualdata_instance_type_name | (((instance_type_name)::text <> ''::text)) |
| vn_systemvirtualdata_state_name | (((state_name)::text <> ''::text)) |
| vn_systemvirtualdata_uuid | (((uuid)::text <> ''::text)) |
| vn_systemvirtualdata_name | (((name)::text <> ''::text)) |
Relationships
Close relationships within degrees of separation
