systempackageupdate


Description

The list of packages that can be updated for a system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 131089 null
system.mgm_id systempackageupdate_system_fkeyR
package.mgm_id systempackageupdate_package_fkeyR

The id of the SUSE Manager instance that contains this data
system_id numeric 131089 null
system.system_id systempackageupdate_system_fkeyR

The id of the system
package_id numeric 131089 null
package.package_id systempackageupdate_package_fkeyR

The id of the package
name varchar 256 √ null

The name of the package
epoch varchar 16 √ null

The epoch of the package
version varchar 512 √ null

The version number of the package
release varchar 512 √ null

The release number of the package
arch varchar 64 √ null

The architecture where the package is installed
type varchar 10 √ null

The type of the package. Possible values: rpm, deb
is_latest bool 1 false

True, if this package is the latest version
synced_date timestamptz 35,6 √ CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

Constraint Name Type Sort Column(s)
systempackageupdate_pk Primary key Asc/Asc/Asc mgm_id + system_id + package_id

Check Constraints

Constraint Name Constraint
vn_systempackageupdate_release (((release)::text <> ''::text))
vn_systempackageupdate_epoch (((epoch)::text <> ''::text))
vn_systempackageupdate_name (((name)::text <> ''::text))
vn_systempackageupdate_type (((type)::text <> ''::text))
vn_systempackageupdate_arch (((arch)::text <> ''::text))
vn_systempackageupdate_version (((version)::text <> ''::text))

Relationships

Close relationships within degrees of separation