Spacewalk DB Schema - Table-RHNPACKAGENAME

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

RHNPACKAGENAME

Columns

Name	Type	Nullable	Default value	Comment
ID	NUMBER(38)	N
NAME	VARCHAR2(256)	N

Primary key:

Constraint Name	Columns
RHN_PN_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_PN_ID_PK	NORMAL	UNIQUE	ID	DDL script
RHN_PN_NAME_UQ	NORMAL	UNIQUE	NAME	DDL script

Referenced by:

Table	Constraint
RHNACTIONPACKAGE	RHN_ACT_P_NAME_FK
RHNACTIONPACKAGEREMOVALFAILURE	RHN_APR_FAILURE_NID_FK
RHNACTIONPACKAGEREMOVALFAILURE	RHN_APR_FAILURE_SUGGESTED_FK
RHNCHANNELNEWESTPACKAGE	RHN_CNP_NID_FK
RHNKICKSTARTPACKAGE	RHN_KSPACKAGE_PNID_FK
RHNPACKAGESYNCBLACKLIST	RHN_PACKAGESYNCBL_PNID_FK
RHNPACKAGE	RHN_PACKAGE_NID_FK
RHNPACKAGENEVRA	RHN_PKGNEVRA_NID_FK
RHNREGTOKENPACKAGES	RHN_REG_TOK_PKG_SGS_FK
RHNSERVERACTIONVERIFYMISSING	RHN_SACTIONVM_PNID_FK
RHNSERVERACTIONVERIFYRESULT	RHN_SACTIONVR_PNID_FK
RHNSERVERCRASH	RHN_SERVER_CRASH_PNAME_ID_FK
RHNSERVERPROFILEPACKAGE	RHN_SPROFILE_NID_FK
RHNTRANSACTIONPACKAGE	RHN_TRANSPACK_NID_FK
RHNVERSIONINFO	RHN_VERSIONINFO_NID_FK
RHNSERVERPACKAGE	SYS_C008780