systemconfigchannel


Description

The list of configuration channels a system is subscribed to

Columns

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

The id of the SUSE Manager instance that contains this data

system_id numeric 131089 null
system.system_id systemconfigchannel_system_fkeyR

The id of the system

config_channel_id numeric 131089 null

The id of the configuration channel

name varchar 128 null

The name of the configuration channel

position numeric 131089 null

The rank of the subscription

synced_date timestamptz 35,6 CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

Constraint Name Type Sort Column(s)
systemconfigchannel_pk Primary key Asc/Asc/Asc mgm_id + system_id + config_channel_id

Check Constraints

Constraint Name Constraint
vn_systemconfigchannel_name (((name)::text <> ''::text))

Relationships