Spacewalk DB Schema - View-RHNSERVERNEEDEDPACKAGECACHE

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

RHNSERVERNEEDEDPACKAGECACHE

Name	Type	Nullable	Insertable	Updatable	Deletable
SERVER_ID	NUMBER(38)	N	NO	NO	NO
PACKAGE_ID	NUMBER(38)	N	NO	NO	NO
ERRATA_ID	NUMBER(38)	Y	NO	NO	NO

Legend: comment string keyword reserved word operator

select
	server_id,
	package_id,
	max(errata_id) as errata_id
	from rhnServerNeededCache
	group by server_id, package_id