Spacewalk DB Schema - View-RHNSHAREDCHANNELTREEVIEW

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

RHNSHAREDCHANNELTREEVIEW

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
ORG_ID	NUMBER(38)	Y	NO	NO	NO
ID	NUMBER(38)	Y	NO	NO	NO
DEPTH	NUMBER(38)	Y	NO	NO	NO
NAME	VARCHAR2(256)	Y	NO	NO	NO
PADDED_NAME	VARCHAR2(258)	Y	NO	NO	NO
CHANNEL_ARCH_ID	NUMBER(38)	Y	NO	NO	NO
LAST_MODIFIED	TIMESTAMP(6) WITH LOCAL TIME ZONE	Y	NO	NO	NO
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
END_OF_LIFE	TIMESTAMP(6) WITH LOCAL TIME ZONE	Y	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

SELECT ORG_ID,ID,DEPTH,NAME,PADDED_NAME,CHANNEL_ARCH_ID,LAST_MODIFIED,LABEL,PARENT_OR_SELF_LABEL,PARENT_OR_SELF_ID,END_OF_LIFE FROM (
  SELECT
    C.ORG_TRUST_ID AS ORG_ID,
    C.ID,
    1 AS DEPTH,
    C.NAME,
    '  '||C.NAME AS PADDED_NAME,
    C.CHANNEL_ARCH_ID,
    C.LAST_MODIFIED,
    C.LABEL,
    C.LABEL AS PARENT_OR_SELF_LABEL,
    C.ID AS PARENT_OR_SELF_ID,
    C.END_OF_LIFE
  FROM RHNSHAREDCHANNELVIEW C
  WHERE C.PARENT_CHANNEL IS NULL
  UNION
  SELECT
    C.ORG_TRUST_ID AS ORG_ID,
    C.ID,
    2 AS DEPTH,
    c.name,
    ''||C.NAME AS PADDED_NAME,
    C.CHANNEL_ARCH_ID,
    C.LAST_MODIFIED,
    C.LABEL,
    PC.LABEL AS PARENT_OR_SELF_LABEL,
    PC.ID AS PARENT_OR_SELF_ID,
    C.END_OF_LIFE
  FROM RHNCHANNEL PC,
       RHNSHAREDCHANNELVIEW C
  WHERE C.PARENT_CHANNEL = PC.ID
) SHARRED
ORDER BY PARENT_OR_SELF_LABEL, PARENT_OR_SELF_ID