Spacewalk DB Schema - View-RHNCHANNELPACKAGEOVERVIEW

Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Sanity Check Index DDL scrips

Description Columns Query Constraints Triggers

RHNCHANNELPACKAGEOVERVIEW

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
CHANNEL_ID	NUMBER(38)	N	NO	NO	NO
NAME_ID	NUMBER(38)	N	NO	NO	NO
EVR	EVR_T	Y	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

select  cp.channel_id,
	p.name_id,
	max(p_evr.evr)
from
	rhnPackageEVR p_evr,
	rhnPackage p,
	rhnChannelPackage cp
where
    	cp.package_id = p.id
    and p.evr_id = p_evr.id
group by cp.channel_id, p.name_id