Spacewalk DB Schema - Table-RHNPACKAGESOURCE

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

RHNPACKAGESOURCE

DDL script

Columns

Name	Type	Nullable	Default value
ID	NUMBER(38)	N
ORG_ID	NUMBER(38)	Y
SOURCE_RPM_ID	NUMBER(38)	N
PACKAGE_GROUP	NUMBER(38)	N
RPM_VERSION	VARCHAR2(16)	N
PAYLOAD_SIZE	NUMBER(38)	N
BUILD_HOST	VARCHAR2(256)	N
BUILD_TIME	TIMESTAMP(6) WITH LOCAL TIME ZONE	N
SIGCHECKSUM_ID	NUMBER(38)	N
VENDOR	VARCHAR2(64)	N
COOKIE	VARCHAR2(128)	N
PATH	VARCHAR2(1000)	Y
CHECKSUM_ID	NUMBER(38)	N
PACKAGE_SIZE	NUMBER(38)	N
LAST_MODIFIED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)
CREATED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)
MODIFIED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)

Primary key:

Constraint Name	Columns
RHN_PKGSRC_ID_PK	ID

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_PKGSRC_CHSUM_FK	CHECKSUM_ID	RHNCHECKSUM	RHNCHECKSUM_PK	NO ACTION
RHN_PKGSRC_GROUP_FK	PACKAGE_GROUP	RHNPACKAGEGROUP	RHN_PACKAGE_GROUP_ID_PK	NO ACTION
RHN_PKGSRC_OID_FK	ORG_ID	WEB_CUSTOMER	WEB_CUSTOMER_ID_PK	CASCADE
RHN_PKGSRC_SIGCHSUM_FK	SIGCHECKSUM_ID	RHNCHECKSUM	RHNCHECKSUM_PK	NO ACTION
RHN_PKGSRC_SRID_FK	SOURCE_RPM_ID	RHNSOURCERPM	RHN_SOURCERPM_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_PKGSRC_ID_PK	NORMAL	UNIQUE	ID	DDL script
RHN_PKGSRC_SRID_OID_UQ	NORMAL	UNIQUE	SOURCE_RPM_ID , ORG_ID	DDL script

Referenced by:

Table	Constraint
RHNERRATAFILEPACKAGESOURCE	RHN_EFILEPS_PID_FK

Triggers

RHN_PKGSRC_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_pkgsrc_mod_trig
before insert or update on rhnPackageSource
for each row

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