| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| mgm_id | numeric | 131089 | null |
|
|
The id of the Uyuni instance that contains this data |
||||||||||||||||||||||||||||||||
| system_id | numeric | 131089 | null |
|
|
The id of the system |
||||||||||||||||||||||||||||||||
| profile_name | varchar | 128 | √ | null |
|
|
The unique descriptive name of the system |
|||||||||||||||||||||||||||||||
| hostname | varchar | 128 | √ | null |
|
|
The hostname that identifies this system |
|||||||||||||||||||||||||||||||
| minion_id | varchar | 256 | √ | null |
|
|
The identifier of the minion, if the system is a Salt Minion |
|||||||||||||||||||||||||||||||
| minion_os_family | varchar | 32 | √ | null |
|
|
The family of the operating system, if the system is a Salt Minion |
|||||||||||||||||||||||||||||||
| minion_kernel_live_version | varchar | 255 | √ | null |
|
|
The current live kernel version, if the system is a Salt Minion |
|||||||||||||||||||||||||||||||
| machine_id | varchar | 256 | √ | null |
|
|
The identifier of the machine |
|||||||||||||||||||||||||||||||
| registered_by | varchar | 64 | √ | null |
|
|
The user account who onboarded this system |
|||||||||||||||||||||||||||||||
| registration_time | timestamptz | 35,6 | √ | null |
|
|
When this system was onboarded |
| Constraint Name | Constraint |
|---|---|
| vn_system_minion_os_family | (((minion_os_family)::text <> ''::text)) |
| vn_system_address1 | (((address1)::text <> ''::text)) |
| vn_system_building | (((building)::text <> ''::text)) |
| vn_system_minion_id | (((minion_id)::text <> ''::text)) |
| vn_system_registered_by | (((registered_by)::text <> ''::text)) |
| vn_system_hostname | (((hostname)::text <> ''::text)) |
| vn_system_city | (((city)::text <> ''::text)) |
| vn_system_country | (((country)::text <> ''::text)) |
| vn_system_state | (((state)::text <> ''::text)) |
| vn_system_architecture | (((architecture)::text <> ''::text)) |
