Spacewalk DB Schema - Table-RHNERRATATMP

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

RHNERRATATMP

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)	Y
DESCRIPTION	VARCHAR2(4000)	Y
SYNOPSIS	VARCHAR2(4000)	Y
TOPIC	VARCHAR2(4000)	Y
SOLUTION	VARCHAR2(4000)	Y
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_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
RHN_ERRATATMP_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_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 := current_timestamp;
        :new.last_modified := current_timestamp;
end;