Spacewalk DB Schema - Table-RHNPACKAGEARCH

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

RHNPACKAGEARCH

DDL script

Columns

Name	Type	Nullable	Default value
ID	NUMBER(38)	N
LABEL	VARCHAR2(64)	N
NAME	VARCHAR2(64)	N
ARCH_TYPE_ID	NUMBER(38)	N
CREATED	DATE	N	(sysdate)
MODIFIED	DATE	N	(sysdate)

Primary key:

Constraint Name	Columns
RHN_PARCH_ID_PK	ID

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_PARCH_ATID_FK	ARCH_TYPE_ID	RHNARCHTYPE	RHN_ARCHTYPE_ID_PK	NO ACTION

Unique Keys:

Constraint name	Columns
RHN_PARCH_LABEL_UQ	LABEL

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_PARCH_ID_L_N_IDX	NORMAL	NONUNIQUE	ID , LABEL , NAME	DDL script
RHN_PARCH_L_ID_N_IDX	NORMAL	NONUNIQUE	LABEL , ID , NAME	DDL script

Referenced by:

Table	Constraint
RHNACTIONPACKAGE	RHN_ACT_P_PAID_FK
RHNBLACKLISTOBSOLETES	RHN_BL_OBS_PAID_FK
RHNCHANNELNEWESTPACKAGE	RHN_CNP_PAID_FK
RHNCHANNELPACKAGEARCHCOMPAT	RHN_CP_AC_PAID_FK
RHNPACKAGE	RHN_PACKAGE_PAID_FK
RHNPACKAGENEVRA	RHN_PKGNEVRA_PAID_FK
RHNSERVERACTIONVERIFYMISSING	RHN_SACTIONVM_PAID_FK
RHNSERVERACTIONVERIFYRESULT	RHN_SACTIONVR_PAID_FK
RHNSERVERPACKAGE	RHN_SERVERPACKAGE_PAID_FK
RHNSERVERPACKAGEARCHCOMPAT	RHN_SP_AC_PAID_FK
RHNTRANSACTIONPACKAGE	RHN_TRANSPACK_PAID_FK

Triggers

RHN_PARCH_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_parch_mod_trig
before insert or update on rhnPackageArch
for each row

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