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