Spacewalk DB Schema - Table-RHNERRATA

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

Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers Partitions

RHNERRATA

DDL script

Columns

Name	Type	Nullable	Default value
ID	NUMBER(38)	N
ADVISORY	VARCHAR2(100)	N
ADVISORY_TYPE	VARCHAR2(32)	N
ADVISORY_NAME	VARCHAR2(100)	N
ADVISORY_REL	NUMBER(38)	N
PRODUCT	VARCHAR2(64)	N
DESCRIPTION	VARCHAR2(4000)	Y
SYNOPSIS	VARCHAR2(4000)	N
TOPIC	VARCHAR2(4000)	Y
SOLUTION	VARCHAR2(4000)	N
ISSUE_DATE	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)
UPDATE_DATE	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)
REFERS_TO	VARCHAR2(4000)	Y
NOTES	VARCHAR2(4000)	Y
ORG_ID	NUMBER(38)	Y
LOCALLY_MODIFIED	CHAR(1)	Y
ERRATA_FROM	VARCHAR2(127)	Y
CREATED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)
MODIFIED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)
LAST_MODIFIED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)
SEVERITY_ID	NUMBER(38)	Y

Primary key:

Constraint Name	Columns
RHN_ERRATA_ID_PK	ID

Check Constraints:

Constraint Name	Check Condition
RHN_ERRATA_ADV_TYPE_CK	advisory_type in ('Bug Fix Advisory', 'Product Enhancement Advisory', 'Security Advisory')
RHN_ERRATA_LM_CK	locally_modified in ('Y','N')

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_ERRATA_OID_FK	ORG_ID	WEB_CUSTOMER	WEB_CUSTOMER_ID_PK	CASCADE
RHN_ERRATA_SEVID_FK	SEVERITY_ID	RHNERRATASEVERITY	RHN_ERRATA_SEV_ID_PK	NO ACTION

Options:

Option	Settings
Tablespace	USERS
Index Organized	No
Generated by Oracle	No
Clustered	No
Nested	No
Temporary	No

Indexes:

Index Name	Type	Unuqueness	Columns	DDL script
RHN_ERRATA_ADVNAME_ORG_UQ	NORMAL	UNIQUE	ADVISORY_NAME , ORG_ID	DDL script
RHN_ERRATA_ADV_ORG_UQ	NORMAL	UNIQUE	ADVISORY , ORG_ID	DDL script
RHN_ERRATA_ID_PK	NORMAL	UNIQUE	ID	DDL script
RHN_ERRATA_SYN_INDEX	NORMAL	NONUNIQUE	SYNOPSIS	DDL script
RHN_ERRATA_UDATE_INDEX	NORMAL	NONUNIQUE	UPDATE_DATE	DDL script

Referenced by:

Table	Constraint
RHNACTIONERRATAUPDATE	RHN_ACT_EU_ERR_FK
RHNCHANNELERRATA	RHN_CE_EID_FK
RHNERRATACLONEDTMP	RHN_ECLONEDTMP_FEID_FK
RHNERRATANOTIFICATIONQUEUE	RHN_ENQUEUE_EID_FK
RHNERRATAQUEUE	RHN_EQUEUE_EID_FK
RHNERRATACLONED	RHN_ERRATACLONE_FEID_FK
RHNERRATACLONED	RHN_ERRATACLONE_TEID_FK
RHNERRATAFILE	RHN_ERRATAFILE_ERRATA_FK
RHNERRATABUGLIST	RHN_ERRATA_BUGLIST_ERRATA_FK
RHNERRATACVE	RHN_ERR_CVE_EID_FK
RHNERRATAKEYWORD	RHN_ERR_KEYWORD_EID_FK
RHNERRATAPACKAGE	RHN_ERR_PKG_EID_FK
RHNSERVERNEEDEDCACHE	RHN_SNCP_EID_FK

Triggers

RHN_ERRATA_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_errata_mod_trig
before insert or update on rhnErrata
for each row

REFERENCING NEW AS NEW OLD AS OLD
begin
     if ( :new.last_modified = :old.last_modified ) or
        ( :new.last_modified is null )  then
        :new.last_modified := current_timestamp;
     end if;

	  	:new.modified := current_timestamp;
end rhn_errata_mod_trig;