The list of channel managed by a SUSE Manager instance


Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 131089 null
channelerrata.mgm_id channelerrata_channel_fkeyR
channelpackage.mgm_id channelpackage_channel_fkeyR
channelrepository.mgm_id channelrepository_channel_fkeyR
systemchannel.mgm_id systemchannel_channel_fkeyR

The id of the SUSE Manager instance that contains this data

channel_id numeric 131089 null
channelerrata.channel_id channelerrata_channel_fkeyR
channelpackage.channel_id channelpackage_channel_fkeyR
channelrepository.channel_id channelrepository_channel_fkeyR
systemchannel.channel_id systemchannel_channel_fkeyR

The id of the channel

name varchar 256 null

The unique name of this channel

label varchar 128 null

The unique label identifying this channel

type varchar 50 null

The type of channel. Possible values: Vendor if installed through the Product wizard, Custom if manually configured

arch varchar 64 null

The architecture of the packages hold by this channel

checksum_type varchar 32 null

The type of checksum used by this channel

summary varchar 500 null

A brief summary of this channel

description varchar 4000 null

A detailed description of the channel scope and purpose

parent_channel_label varchar 128 null

The label of the parent of this channel, if exists

original_channel_id numeric 131089 null

If the channel is a clone, the id of the original channel

organization varchar 128 null

The organization that owns this data

synced_date timestamptz 35,6 CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.


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

Check Constraints

Constraint Name Constraint
vn_channel_type (((type)::text <> ''::text))
vn_channel_name (((name)::text <> ''::text))
vn_channel_organization (((organization)::text <> ''::text))
vn_channel_summary (((summary)::text <> ''::text))
vn_channel_parent_channel_label (((parent_channel_label)::text <> ''::text))
vn_channel_label (((label)::text <> ''::text))
vn_channel_description (((description)::text <> ''::text))
vn_channel_arch (((arch)::text <> ''::text))
vn_channel_checksum_type (((checksum_type)::text <> ''::text))