Spacewalk 0.6 DB Schema - View-RHNAVAILABLECHANNELS

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

Description Columns Query Constraints Triggers

RHNAVAILABLECHANNELS

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
ORG_ID	NUMBER(38)	Y	NO	NO	NO
CHANNEL_ID	NUMBER(38)	Y	NO	NO	NO
CHANNEL_DEPTH	NUMBER(38)	Y	NO	NO	NO
CHANNEL_NAME	VARCHAR2(256)	Y	NO	NO	NO
CHANNEL_ARCH_ID	NUMBER(38)	Y	NO	NO	NO
PADDED_NAME	VARCHAR2(258)	Y	NO	NO	NO
CURRENT_MEMBERS	NUMBER(38)	Y	NO	NO	NO
AVAILABLE_MEMBERS	NUMBER(38)	Y	NO	NO	NO
LAST_MODIFIED	DATE	Y	NO	NO	NO
CHANNEL_LABEL	VARCHAR2(128)	Y	NO	NO	NO
PARENT_OR_SELF_LABEL	VARCHAR2(128)	Y	NO	NO	NO
PARENT_OR_SELF_ID	NUMBER(38)	Y	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

select
     ct.org_id,
     ct.id,
     CT.depth,
     CT.name,
     CT.channel_arch_id,
     CT.padded_name,
    (SELECT COUNT(1)
     FROM rhnServer S
     INNER JOIN rhnServerChannel SC
       ON SC.server_id = S.id
     WHERE SC.channel_id = CT.id AND
           S.org_id = CT.org_id),
     rhn_channel.available_chan_subscriptions(ct.id, ct.org_id),
     CT.last_modified,
     CT.label,
     CT.parent_or_self_label,
     CT.parent_or_self_id
from
     rhnOrgChannelTreeView CT
UNION
select
     ct.org_id,
     ct.id,
     CT.depth,
     CT.name,
     CT.channel_arch_id,
     CT.padded_name,
    (SELECT COUNT(1)
     FROM rhnServer S
     INNER JOIN rhnServerChannel SC
       ON SC.server_id = S.id
     WHERE SC.channel_id = CT.id AND
           S.org_id = CT.org_id),
     NULL,
     CT.last_modified,
     CT.label,
     CT.parent_or_self_label,
     CT.parent_or_self_id
from
     rhnSharedChannelTreeView CT