Spacewalk DB Schema - Table-RHNPACKAGEEVR

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

RHNPACKAGEEVR

Columns

Name	Type	Nullable	Default value	Comment
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	DATA_TBS
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
RHNBLACKLISTOBSOLETES	RHN_BL_OBS_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
RHNSERVERPACKAGE	RHN_SERVERPACKAGE_EID_FK
RHNSERVERPROFILEPACKAGE	RHN_SPROFILE_EVRID_FK
RHNTRANSACTIONPACKAGE	RHN_TRANSPACK_EID_FK
RHNVERSIONINFO	RHN_VERSIONINFO_EID_FK