Spacewalk DB Schema - Table-RHNPACKAGECAPABILITY

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

RHNPACKAGECAPABILITY

DDL script

Columns

Name	Type	Nullable	Default value
ID	NUMBER(38)	N
NAME	VARCHAR2(4000)	N
VERSION	VARCHAR2(512)	Y
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_PKG_CAPABILITY_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_PKG_CAPABILITY_ID_PK	NORMAL	UNIQUE	ID	DDL script
RHN_PKG_CAP_NAME_VERSION_UQ	NORMAL	UNIQUE	NAME , VERSION	DDL script

Referenced by:

Table	Constraint
RHNACTIONPACKAGEREMOVALFAILURE	RHN_APR_FAILURE_CAPID_FK
RHNPACKAGEFILE	RHN_PACKAGE_FILE_CID_FK
RHNPACKAGEBREAKS	RHN_PKG_BRKS_CAPABILITY_FK
RHNPACKAGECONFLICTS	RHN_PKG_CONFLICTS_CAP_FK
RHNPACKAGEENHANCES	RHN_PKG_ENH_CAPABILITY_FK
RHNPACKAGEOBSOLETES	RHN_PKG_OBSOLETES_CAP_FK
RHNPACKAGEPREDEPENDS	RHN_PKG_PDEP_CAPABILITY_FK
RHNPACKAGEPROVIDES	RHN_PKG_PROVIDES_CAPABILITY_FK
RHNPACKAGERECOMMENDS	RHN_PKG_REC_CAPABILITY_FK
RHNPACKAGEREQUIRES	RHN_PKG_REQUIRES_CAPABILITY_FK
RHNPACKAGESUGGESTS	RHN_PKG_SUGG_CAPABILITY_FK
RHNPACKAGESUPPLEMENTS	RHN_PKG_SUPP_CAPABILITY_FK
RHNSERVERACTIONVERIFYMISSING	RHN_SACTIONVM_PCID_FK
RHNSERVERACTIONVERIFYRESULT	RHN_SACTIONVR_PCID_FK

Triggers

RHN_PKG_CAPABILITY_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_pkg_capability_mod_trig
before insert or update on rhnPackageCapability
for each row

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