systemerrata


Description

The list of patches applicable to a system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 0 null
system.mgm_id systemerrata_system_fkeyR
errata.mgm_id systemerrata_errata_fkeyR

The id of the SUSE Multi-Linux Manager instance that contains this data
system_id numeric 0 null
system.system_id systemerrata_system_fkeyR

The id of the system
errata_id numeric 0 null
errata.errata_id systemerrata_errata_fkeyR

The id of the patch
hostname varchar 128 √ null

The hostname that identifies the system
advisory_name varchar 100 √ null

The unique name of the advisory
advisory_type varchar 32 √ null

The type of patch. Possible values: Product Enhancement Advisory, Security Advisory, Bug Fix Advisory
synced_date timestamptz 35,6 √ CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

Constraint Name Type Sort Column(s)
systemerrata_pk Primary key Asc/Asc/Asc mgm_id + system_id + errata_id

Check Constraints

Constraint Name Constraint
vn_systemerrata_advisory_name (((advisory_name)::text <> ''::text))
vn_systemerrata_hostname (((hostname)::text <> ''::text))
vn_systemerrata_advisory_type (((advisory_type)::text <> ''::text))

Relationships

Close relationships within degrees of separation