Spacewalk DB Schema - View-RHNSERVERGROUPMEMBERSHIP

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

Description Columns Query Constraints Triggers

RHNSERVERGROUPMEMBERSHIP

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
ORG_ID	NUMBER(38)	N	NO	NO	NO
SERVER_ID	NUMBER(38)	Y	NO	NO	NO
GROUP_ID	NUMBER(38)	N	NO	NO	NO
GROUP_NAME	VARCHAR2(64)	N	NO	NO	NO
GROUP_TYPE	VARCHAR2(32)	Y	NO	NO	NO
CURRENT_MEMBERS	NUMBER(38)	N	NO	NO	NO
MAX_MEMBERS	NUMBER(38)	Y	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

SELECT   SG.org_id, SGM.server_id, SG.id, SG.name, SGT.label, SG.current_members, SG.max_members
  FROM   rhnServerGroupType SGT,
	 rhnServerGroupMembers SGM,
    	 rhnServerGroup SG
 WHERE   SG.id = SGM.server_group_id(+)
   AND   SG.group_type = SGT.id(+)