The list of patches distributed by a channel


Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 131089 null
errata.mgm_id channelerrata_errata_fkeyR
channel.mgm_id channelerrata_channel_fkeyR

The id of the SUSE Manager instance that contains this data

channel_id numeric 131089 null
channel.channel_id channelerrata_channel_fkeyR

The id of the channel

errata_id numeric 131089 null
errata.errata_id channelerrata_errata_fkeyR

The id of the patch

channel_label varchar 128 null

The label of the channel containing this patch

advisory_name varchar 100 null

The advisory name of this patch

synced_date timestamptz 35,6 CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.


Constraint Name Type Sort Column(s)
channelerrata_pk Primary key Asc/Asc/Asc mgm_id + channel_id + errata_id

Check Constraints

Constraint Name Constraint
vn_channelerrata_channel_label (((channel_label)::text <> ''::text))
vn_channelerrata_advisory_name (((advisory_name)::text <> ''::text))