systempackageinstalled


Description

The list of the packages installed on a system

Columns

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

The id of the SUSE Manager instance that contains this data

system_id numeric 131089 null
system.system_id systempackageinstalled_system_fkeyR

The id of the system

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

synced_date timestamptz 35,6 CURRENT_TIMESTAMP

The timestamp of when this data was last refreshed.

Indexes

Constraint Name Type Sort Column(s)
systempackageinstalled_order_idx Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc mgm_id + system_id + name + epoch + version + release + arch + type

Check Constraints

Constraint Name Constraint
vn_systempackageinstalled_arch (((arch)::text <> ''::text))
vn_systempackageinstalled_type (((type)::text <> ''::text))
vn_systempackageinstalled_version (((version)::text <> ''::text))
vn_systempackageinstalled_epoch (((epoch)::text <> ''::text))
vn_systempackageinstalled_release (((release)::text <> ''::text))
vn_systempackageinstalled_name (((name)::text <> ''::text))

Relationships