The list of repositories managed by a SUSE Manager instance


Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 131089 null
channelrepository.mgm_id channelrepository_repository_fkeyR

The id of the SUSE Manager instance that contains this data

repository_id numeric 131089 null
channelrepository.repository_id channelrepository_repository_fkeyR

The id of the repository

label varchar 128 null

The unique label of the repository

url varchar 2048 null

The url where the repository is reachable

type varchar 32 null

The type of the repository. Possible values: yum, uln, deb

metadata_signed bool 1 null

True if the metadata of this repositories is signed

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)
repository_pk Primary key Asc/Asc mgm_id + repository_id

Check Constraints

Constraint Name Constraint
vn_repository_url (((url)::text <> ''::text))
vn_repository_organization (((organization)::text <> ''::text))
vn_repository_type (((type)::text <> ''::text))
vn_repository_label (((label)::text <> ''::text))