Spacewalk DB Schema - View-RHNSERVERENTITLEMENTVIEW

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

RHNSERVERENTITLEMENTVIEW

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
SERVER_ID	NUMBER(38)	N	NO	NO	NO
SERVER_GROUP_TYPE_ID	NUMBER(38)	N	NO	NO	NO
LABEL	VARCHAR2(32)	N	NO	NO	NO
PERMANENT	CHAR(1)	N	NO	NO	NO
IS_BASE	CHAR(1)	N	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

select
   distinct
   sgm.server_id,
   sgt.id,
   sgt.label,
   sgt.permanent,
   sgt.is_base
from
   rhnServerGroupType sgt,
   rhnServerGroup sg,
   rhnServerGroupMembers sgm
where
   sg.id = sgm.server_group_id
   and sg.group_type = sgt.id