systemchannel


Description

The list of channels a system is subscribed to

Columns

Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 131089 null
system.mgm_id systemchannel_system_fkeyR
channel.mgm_id systemchannel_channel_fkeyR

The id of the SUSE Manager instance that contains this data

system_id numeric 131089 null
system.system_id systemchannel_system_fkeyR

The id of the system

channel_id numeric 131089 null
channel.channel_id systemchannel_channel_fkeyR

The id of the channel

name varchar 256 null

The name of the channel

description varchar 4000 null

A detailed description of the channel scope and purpose

architecture_name varchar 64 null

The architecture of the packages hold by this channel

parent_channel_id numeric 131089 null

The id of the parent of this channel, if exists

parent_channel_name varchar 256 null

The name of the parent of this channel, if exists

synced_date timestamptz 35,6 CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

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

Check Constraints

Constraint Name Constraint
vn_systemchannel_description (((description)::text <> ''::text))
vn_systemchannel_parent_channel_name (((parent_channel_name)::text <> ''::text))
vn_systemchannel_architecture_name (((architecture_name)::text <> ''::text))
vn_systemchannel_name (((name)::text <> ''::text))

Relationships