Spacewalk DB Schema - View-RHNSERVERGROUPMEMBERSHIP

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

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

Query:

Legend: comment string keyword reserved word operator

SELECT   SG.org_id, SGM.server_id, SG.id, SG.name, SGT.label, SG.current_members
  FROM
	 rhnServerGroupMembers SGM
             right join
    	 rhnServerGroup SG on (SG.id = SGM.server_group_id)
             left join
         rhnServerGroupType SGT on (SG.group_type = SGT.id)