Spacewalk DB Schema - View-RHNUSERTYPEARRAY

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

Description Columns Query Constraints Triggers

RHNUSERTYPEARRAY

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
USER_ID	NUMBER(38)	N	YES	YES	YES
TYPE_ID_T	USER_GROUP_ID_T	Y	NO	NO	NO
TYPE_LABEL_T	USER_GROUP_LABEL_T	Y	NO	NO	NO
TYPE_NAME_T	USER_GROUP_NAME_T	Y	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

select
    U.id,
    cast(multiset(select utb.type_id
    	    	  from rhnUserTypeBase utb
    	    	  where utb.user_id = u.id)
	 as user_group_id_t),
    cast(multiset(select utb.type_label
    	    	  from rhnUserTypeBase utb
    	    	  where utb.user_id = u.id)
	 as user_group_label_t),
    cast(multiset(select utb.type_name
    	    	  from rhnUserTypeBase utb
    	    	  where utb.user_id = u.id)
	 as user_group_name_t)
from
    web_contact u