Spacewalk DB Schema - Table-RHNPACKAGE

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

RHNPACKAGE

DDL script

Columns

Name	Type	Nullable	Default value
ID	NUMBER(38)	N
ORG_ID	NUMBER(38)	Y
NAME_ID	NUMBER(38)	N
EVR_ID	NUMBER(38)	N
PACKAGE_ARCH_ID	NUMBER(38)	N
PACKAGE_GROUP	NUMBER(38)	Y
RPM_VERSION	VARCHAR2(16)	Y
DESCRIPTION	VARCHAR2(4000)	Y
SUMMARY	VARCHAR2(4000)	Y
PACKAGE_SIZE	NUMBER(38)	N
PAYLOAD_SIZE	NUMBER(38)	Y
BUILD_HOST	VARCHAR2(256)	Y
BUILD_TIME	DATE	Y
SOURCE_RPM_ID	NUMBER(38)	Y
MD5SUM	VARCHAR2(64)	N
VENDOR	VARCHAR2(64)	N
PAYLOAD_FORMAT	VARCHAR2(32)	Y
COMPAT	NUMBER(38)	Y	0
PATH	VARCHAR2(1000)	Y
HEADER_SIG	VARCHAR2(64)	Y
COPYRIGHT	VARCHAR2(64)	Y
COOKIE	VARCHAR2(128)	Y
LAST_MODIFIED	DATE	N	(sysdate)
CREATED	DATE	N	(sysdate)
MODIFIED	DATE	N	(sysdate)
HEADER_START	NUMBER(38)	N	-1
HEADER_END	NUMBER(38)	N	-1

Primary key:

Constraint Name	Columns
RHN_PACKAGE_ID_PK	ID

Check Constraints:

Constraint Name	Check Condition
RHN_PACKAGE_COMPAT_CHECK	compat in (1,0)

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_PACKAGE_EID_FK	EVR_ID	RHNPACKAGEEVR	RHN_PE_ID_PK	NO ACTION
RHN_PACKAGE_GROUP_FK	PACKAGE_GROUP	RHNPACKAGEGROUP	RHN_PACKAGE_GROUP_ID_PK	NO ACTION
RHN_PACKAGE_NID_FK	NAME_ID	RHNPACKAGENAME	RHN_PN_ID_PK	NO ACTION
RHN_PACKAGE_OID_FK	ORG_ID	WEB_CUSTOMER	WEB_CUSTOMER_ID_PK	CASCADE
RHN_PACKAGE_PAID_FK	PACKAGE_ARCH_ID	RHNPACKAGEARCH	RHN_PARCH_ID_PK	NO ACTION
RHN_PACKAGE_SRCRPMID_FK	SOURCE_RPM_ID	RHNSOURCERPM	RHN_SOURCERPM_ID_PK	NO ACTION

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_PACKAGE_ID_NID_PAID_IDX	NORMAL	NONUNIQUE	ID , NAME_ID , PACKAGE_ARCH_ID	DDL script
RHN_PACKAGE_ID_PK	NORMAL	UNIQUE	ID	DDL script
RHN_PACKAGE_MD5_NID_EID_OID_UQ	NORMAL	UNIQUE	MD5SUM , NAME_ID , EVR_ID , ORG_ID	DDL script
RHN_PACKAGE_NID_ID_IDX	NORMAL	NONUNIQUE	NAME_ID , ID	DDL script
RHN_PACKAGE_N_E_PA_O_UQ	NORMAL	UNIQUE	NAME_ID , EVR_ID , PACKAGE_ARCH_ID , ORG_ID	DDL script
RHN_PACKAGE_OID_ID_IDX	NORMAL	NONUNIQUE	ORG_ID , ID	DDL script

Referenced by:

Table	Constraint
RHNCHANNELNEWESTPACKAGE	RHN_CNP_PID_FK
RHNCHANNELPACKAGE	RHN_CP_PID_FK
RHNERRATAFILEPACKAGETMP	RHN_EFILEPTMP_PID_FK
RHNERRATAFILEPACKAGE	RHN_EFILEP_PID_FK
RHNERRATAPACKAGETMP	RHN_ERR_PKGTMP_PID_FK
RHNERRATAPACKAGE	RHN_ERR_PKG_PID_FK
RHNPACKAGEFILE	RHN_PACKAGE_FILE_PID_FK
RHNPACKAGECHANGELOG	RHN_PKG_CHANGELOG_PID_FK
RHNPACKAGECONFLICTS	RHN_PKG_CONFLICTS_PACKAGE_FK
RHNPACKAGEOBSOLETES	RHN_PKG_OBSOLETES_PACKAGE_FK
RHNPACKAGEPROVIDES	RHN_PKG_PROVIDES_PACKAGE_FK
RHNPACKAGEREQUIRES	RHN_PKG_REQUIRES_PACKAGE_FK
RHNPACKAGESIGNATURE	RHN_PKG_SIG_PID_FK
RHNSERVERNEEDEDPACKAGECACHE	RHN_SNCP_PID_FK
RHNSOLARISPATCHEDPACKAGE	RHN_SOLARIS_PATCHEDP_PID_FK
RHNSOLARISPACKAGE	RHN_SOLARIS_PKG_PID_FK
RHNSOLARISPATCHPACKAGES	RHN_SOLARIS_PP_FK
RHNSOLARISPATCHSETMEMBERS	RHN_SOLARIS_PSM_PID_FK
RHNSOLARISPATCHSETMEMBERS	RHN_SOLARIS_PSM_PSID_FK
RHNSOLARISPATCHSET	RHN_SOLARIS_PS_PID_FK
RHNSOLARISPATCH	RHN_SOLARIS_P_FK

Triggers

RHN_PACKAGE_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_package_mod_trig
before insert or update on rhnPackage
for each row

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