channelrepository


Description

The list of the repositories of a channel

Columns

Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 131089 null
repository.mgm_id channelrepository_repository_fkeyR
channel.mgm_id channelrepository_channel_fkeyR

The id of the SUSE Manager instance that contains this data
channel_id numeric 131089 null
channel.channel_id channelrepository_channel_fkeyR

The id of the channel
repository_id numeric 131089 null
repository.repository_id channelrepository_repository_fkeyR

The id of the repository
repository_label varchar 128 √ null

The unique label of the repository
synced_date timestamptz 35,6 √ CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

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

Check Constraints

Constraint Name Constraint
vn_channelrepository_repository_label (((repository_label)::text <> ''::text))

Relationships

Close relationships within degrees of separation