Spacewalk DB Schema - Table-RHNERRATATMP

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

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

RHNERRATATMP

DDL script

Columns

Name	Type	Nullable	Default value
ID	NUMBER(38)	N
ADVISORY	VARCHAR2(32)	N
ADVISORY_TYPE	VARCHAR2(32)	N
ADVISORY_NAME	VARCHAR2(32)	N
ADVISORY_REL	NUMBER(38)	N
PRODUCT	VARCHAR2(64)	Y
DESCRIPTION	VARCHAR2(4000)	Y
SYNOPSIS	VARCHAR2(4000)	Y
TOPIC	VARCHAR2(4000)	Y
SOLUTION	VARCHAR2(4000)	Y
ISSUE_DATE	DATE	N	(sysdate)
UPDATE_DATE	DATE	N	(sysdate)
REFERS_TO	VARCHAR2(4000)	Y
NOTES	VARCHAR2(4000)	Y
ORG_ID	NUMBER(38)	Y
LOCALLY_MODIFIED	CHAR(1)	Y
CREATED	DATE	N	(sysdate)
MODIFIED	DATE	N	(sysdate)
LAST_MODIFIED	DATE	N	(sysdate)

Primary key:

Constraint Name	Columns
RHN_ERRATATMP_ID_PK	ID

Check Constraints:

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

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_ERRATATMP_OID_FK	ORG_ID	WEB_CUSTOMER	WEB_CUSTOMER_ID_PK	CASCADE

Options:

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

Indexes:

Index Name	Type	Unuqueness	Columns	DDL script
RHN_ERRATATMP_ADVISORY_NAME_UQ	NORMAL	UNIQUE	ADVISORY_NAME	DDL script
RHN_ERRATATMP_ADVISORY_UQ	NORMAL	UNIQUE	ADVISORY	DDL script
RHN_ERRATATMP_ID_PK	NORMAL	UNIQUE	ID	DDL script

Referenced by:

Table	Constraint
RHNERRATACLONEDTMP	RHN_ECLONEDTMP_TEID_FK
RHNERRATAFILETMP	RHN_ERRATAFILETMP_ERRATA_FK
RHNERRATABUGLISTTMP	RHN_ERRATA_BUGLISTTMP_EID_FK
RHNERRATAKEYWORDTMP	RHN_ERR_KEYWORDTMP_EID_FK
RHNERRATAPACKAGETMP	RHN_ERR_PKGTMP_EID_FK

Triggers

RHN_ERRATATMP_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_erratatmp_mod_trig
before insert or update on rhnerratatmp
for each row

REFERENCING NEW AS NEW OLD AS OLD
begin
        :new.modified := sysdate;
        :new.last_modified := sysdate;
end;