Spacewalk DB Schema - View-RHNSERVERGROUPOVLITEHELPER

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

Description Columns Query Constraints Triggers

RHNSERVERGROUPOVLITEHELPER

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable	Comment
SERVER_GROUP_ID	NUMBER(38)	N	NO	NO	NO
ADVISORY_TYPE	VARCHAR2(32)	N	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

select	sgm.server_group_id						as server_group_id,
		e.advisory_type							as advisory_type
from	rhnErrata								e,
		rhnServerNeededPackageCache				snpc,
		rhnServerGroupMembers					sgm
where   sgm.server_id = snpc.server_id
	and snpc.errata_id = e.id