Spacewalk DB Schema - Table-RHNPACKAGEEVR

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

RHNPACKAGEEVR

DDL script

Columns

Name	Type	Nullable
ID	NUMBER(38)	N
EPOCH	VARCHAR2(16)	Y
VERSION	VARCHAR2(512)	N
RELEASE	VARCHAR2(512)	N
EVR	EVR_T	N

Primary key:

Constraint Name	Columns
RHN_PE_ID_PK	ID

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_PE_ID_PK	NORMAL	UNIQUE	ID	DDL script
RHN_PE_V_R_E_UQ	NORMAL	UNIQUE	VERSION , RELEASE , EPOCH	DDL script

Referenced by:

Table	Constraint
RHNACTIONPACKAGE	RHN_ACT_P_EVR_FK
RHNACTIONPACKAGEREMOVALFAILURE	RHN_APR_FAILURE_EID_FK
RHNCHANNELNEWESTPACKAGE	RHN_CNP_EID_FK
RHNPACKAGE	RHN_PACKAGE_EID_FK
RHNPACKAGENEVRA	RHN_PKGNEVRA_EID_FK
RHNPROXYINFO	RHN_PROXY_INFO_PEID_FK
RHNSERVERACTIONVERIFYMISSING	RHN_SACTIONVM_PEID_FK
RHNSERVERACTIONVERIFYRESULT	RHN_SACTIONVR_PEID_FK
RHNSATELLITEINFO	RHN_SATELLITE_INFO_EID_FK
RHNSERVERCRASH	RHN_SERVER_CRASH_EVR_ID_FK
RHNSERVERPROFILEPACKAGE	RHN_SPROFILE_EVRID_FK
RHNTRANSACTIONPACKAGE	RHN_TRANSPACK_EID_FK
RHNVERSIONINFO	RHN_VERSIONINFO_EID_FK
RHNSERVERPACKAGE	SYS_C008781

Triggers

RHN_PACK_EVR_NO_UPDEL_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_pack_evr_no_updel_trig
before update or delete on rhnPackageEvr

REFERENCING NEW AS NEW OLD AS OLD
declare
	operation varchar(20);
begin
	if updating then
		operation := 'UPDATE';
	elsif deleting then
		operation := 'DELETE';
	else
		raise_application_error(-20051, 'Unknown operation (no UPDATE and no DELETE)');
	end if;
	raise_application_error(-20050, 'Permission denied: ' || operation || ' is not allowed on RHNPACKAGEEVR');
end;