Spacewalk DB Schema - View-RHNORGDISTCHANNELMAP

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

RHNORGDISTCHANNELMAP

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
ID	NUMBER(38)	Y	NO	NO	NO
FOR_ORG_ID	NUMBER(38)	N	NO	NO	NO
ORG_ID	NUMBER(38)	Y	NO	NO	NO
OS	VARCHAR2(64)	Y	NO	NO	NO
RELEASE	VARCHAR2(64)	Y	NO	NO	NO
CHANNEL_ARCH_ID	NUMBER(38)	Y	NO	NO	NO
CHANNEL_ID	NUMBER(38)	Y	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

SELECT CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.id ELSE dcm_n.id END id,
        o.id as for_org_id,
        dcm_o.org_id,
        CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.os ELSE dcm_n.os END os,
        CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.release ELSE dcm_n.release END as release,
        CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.channel_arch_id ELSE dcm_n.channel_arch_id END as channel_arch_id,
        CASE WHEN dcm_o.org_id IS NOT NULL THEN dcm_o.channel_id ELSE dcm_n.channel_id END as channel_id
FROM web_customer o
    JOIN (SELECT DISTINCT release, channel_arch_id from rhnDistChannelMap) dcm ON 1 = 1
    LEFT JOIN rhnDistChannelMap dcm_n ON dcm_n.org_id IS NULL
        AND dcm_n.release = dcm.release
        AND dcm_n.channel_arch_id = dcm.channel_arch_id
    LEFT JOIN rhnDistChannelMap dcm_o ON dcm_o.org_id = o.id
        AND dcm_o.release = dcm.release
        AND dcm_o.channel_arch_id = dcm.channel_arch_id
WHERE (dcm_o.channel_id IS NOT NULL OR dcm_n.channel_id IS NOT NULL)
ORDER BY org_id, release, channel_arch_id