systemhistory


Description

The history events associated to a system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 131089 null
system.mgm_id systemhistory_system_fkeyR

The id of the SUSE Manager instance that contains this data

system_id numeric 131089 null
system.system_id systemhistory_system_fkeyR

The id of the system

history_id numeric 131089 null

The id of the history event

hostname varchar 128 null

The hostname that identifies the system

event varchar 100 null

The type of history event

event_data text 2147483647 null

Additional information related to the event

event_time timestamptz 35,6 null

When this event has happened

synced_date timestamptz 35,6 CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

Constraint Name Type Sort Column(s)
systemhistory_pk Primary key Asc/Asc/Asc mgm_id + system_id + history_id

Check Constraints

Constraint Name Constraint
vn_systemhistory_hostname (((hostname)::text <> ''::text))
vn_systemhistory_event (((event)::text <> ''::text))

Relationships