Spacewalk DB Schema - View-RHNUSERTYPEBASE

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

RHNUSERTYPEBASE

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
USER_ID	NUMBER(38)	N	NO	NO	NO
TYPE_ID	NUMBER(38)	N	NO	NO	NO
TYPE_LABEL	VARCHAR2(64)	N	NO	NO	NO
TYPE_NAME	VARCHAR2(64)	N	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

select distinct
    ugm.user_id, ugt.id, ugt.label, ugt.name
from
    rhnUserGroupMembers ugm, rhnUserGroupType ugt, rhnUserGroup ug
where
    ugm.user_group_id = ug.id
and ugt.id = ug.group_type