Spacewalk DB Schema - View-RHNSHAREDCHANNELVIEW

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

RHNSHAREDCHANNELVIEW

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
ID	NUMBER(38)	Y	NO	NO	NO
PARENT_CHANNEL	NUMBER(38)	Y	NO	NO	NO
ORG_ID	NUMBER(38)	Y	NO	NO	NO
CHANNEL_ARCH_ID	NUMBER(38)	Y	NO	NO	NO
LABEL	VARCHAR2(128)	Y	NO	NO	NO
BASEDIR	VARCHAR2(256)	Y	NO	NO	NO
NAME	VARCHAR2(256)	Y	NO	NO	NO
SUMMARY	VARCHAR2(500)	Y	NO	NO	NO
DESCRIPTION	VARCHAR2(4000)	Y	NO	NO	NO
PRODUCT_NAME_ID	NUMBER(38)	Y	NO	NO	NO
GPG_KEY_URL	VARCHAR2(256)	Y	NO	NO	NO
GPG_KEY_ID	VARCHAR2(14)	Y	NO	NO	NO
GPG_KEY_FP	VARCHAR2(50)	Y	NO	NO	NO
END_OF_LIFE	TIMESTAMP(6) WITH LOCAL TIME ZONE	Y	NO	NO	NO
RECEIVING_UPDATES	CHAR(1)	Y	NO	NO	NO
LAST_MODIFIED	TIMESTAMP(6) WITH LOCAL TIME ZONE	Y	NO	NO	NO
CHANNEL_PRODUCT_ID	NUMBER(38)	Y	NO	NO	NO
CREATED	TIMESTAMP(6) WITH LOCAL TIME ZONE	Y	NO	NO	NO
MODIFIED	TIMESTAMP(6) WITH LOCAL TIME ZONE	Y	NO	NO	NO
CHANNEL_ACCESS	VARCHAR2(10)	Y	NO	NO	NO
ORG_TRUST_ID	NUMBER(38)	Y	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

SELECT
   CH.ID,
   CH.PARENT_CHANNEL,
   CH.ORG_ID,
   CH.CHANNEL_ARCH_ID,
   CH.LABEL,
   CH.BASEDIR,
   CH.NAME,
   CH.SUMMARY,
   CH.DESCRIPTION,
   CH.PRODUCT_NAME_ID,
   CH.GPG_KEY_URL,
   CH.GPG_KEY_ID,
   CH.GPG_KEY_FP,
   CH.END_OF_LIFE,
   CH.RECEIVING_UPDATES,
   CH.LAST_MODIFIED,
   CH.CHANNEL_PRODUCT_ID,
   CH.CREATED,
   CH.MODIFIED,
   CH.CHANNEL_ACCESS,
   TR.ORG_TRUST_ID
FROM RHNCHANNEL CH,
     RHNTRUSTEDORGS TR
WHERE CH.ORG_ID = TR.ORG_ID AND
      CH.CHANNEL_ACCESS = 'public'
UNION
SELECT
   CH.ID,
   CH.PARENT_CHANNEL,
   CH.ORG_ID,
   CH.CHANNEL_ARCH_ID,
   CH.LABEL,
   CH.BASEDIR,
   CH.NAME,
   CH.SUMMARY,
   CH.DESCRIPTION,
   CH.PRODUCT_NAME_ID,
   CH.GPG_KEY_URL,
   CH.GPG_KEY_ID,
   CH.GPG_KEY_FP,
   CH.END_OF_LIFE,
   CH.RECEIVING_UPDATES,
   CH.LAST_MODIFIED,
   CH.CHANNEL_PRODUCT_ID,
   CH.CREATED,
   CH.MODIFIED,
   CH.CHANNEL_ACCESS,
   TR.ORG_TRUST_ID
FROM RHNCHANNEL CH,
     RHNCHANNELTRUST TR
WHERE CH.ID = TR.CHANNEL_ID AND
      CH.CHANNEL_ACCESS = 'protected'