Spacewalk DB Schema - Table-RHNCONFIGREVISION

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

RHNCONFIGREVISION

DDL script

Columns

Name	Type	Nullable	Default value
ID	NUMBER(38)	N
REVISION	NUMBER(38)	N
CONFIG_FILE_ID	NUMBER(38)	N
CONFIG_CONTENT_ID	NUMBER(38)	Y
CONFIG_INFO_ID	NUMBER(38)	N
CREATED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)
MODIFIED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)
CONFIG_FILE_TYPE_ID	NUMBER(38)	N	(1)
CHANGED_BY_ID	NUMBER(38)	Y	(null)

Primary key:

Constraint Name	Columns
RHN_CONFREVISION_ID_PK	ID

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_CONFREVISION_CCID_FK	CONFIG_CONTENT_ID	RHNCONFIGCONTENT	RHN_CONFCONTENT_ID_PK	NO ACTION
RHN_CONFREVISION_CFID_FK	CONFIG_FILE_ID	RHNCONFIGFILE	RHN_CONFFILE_ID_PK	NO ACTION
RHN_CONFREVISION_CID_FK	CHANGED_BY_ID	WEB_CONTACT	WEB_CONTACT_PK	NO ACTION
RHN_CONFREVISION_CIID_FK	CONFIG_INFO_ID	RHNCONFIGINFO	RHN_CONFINFO_ID_PK	NO ACTION
RHN_CONF_REV_CFTI_FK	CONFIG_FILE_TYPE_ID	RHNCONFIGFILETYPE	RHN_CONFFILETYPE_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_CONFREVISION_CCID_IDX	NORMAL	NONUNIQUE	CONFIG_CONTENT_ID	DDL script
RHN_CONFREVISION_CFID_REV_UQ	NORMAL	UNIQUE	CONFIG_FILE_ID , REVISION	DDL script
RHN_CONFREVISION_ID_PK	NORMAL	UNIQUE	ID	DDL script

Referenced by:

Table	Constraint
RHNACTIONCONFIGFILENAME	RHN_ACTIONCF_NAME_CRID_FK
RHNACTIONCONFIGREVISION	RHN_ACTIONCR_CRID_FK
RHNCONFIGFILE	RHN_CONFFILE_LCRID_FK
RHNSNAPSHOTCONFIGREVISION	RHN_SNAPSHOTCR_CRID_FK

Triggers

RHN_CONFREVISION_DEL_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_confrevision_del_trig
before delete on rhnConfigRevision
for each row

REFERENCING NEW AS NEW OLD AS OLD
declare
        cr_removed number := lookup_snapshot_invalid_reason('cr_removed');
begin
        update rhnSnapshot
           set invalid = cr_removed
         where id in (select snapshot_id
                        from rhnSnapshotConfigRevision
                       where config_revision_id = :old.id);
        delete from rhnSnapshotConfigRevision
         where config_revision_id = :old.id;
end;

RHN_CONFREVISION_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_confrevision_mod_trig
before insert or update on rhnConfigRevision
for each row

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