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

RHNSERVERPROFILEPACKAGE

DDL script

Columns

NameTypeNullableDefault valueComment
SERVER_PROFILE_IDNUMBER(38)N  
NAME_IDNUMBER(38)N  
EVR_IDNUMBER(38)N  
PACKAGE_ARCH_IDNUMBER(38)Y  

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
RHN_SPROFILE_EVRID_FKEVR_ID RHNPACKAGEEVR RHN_PE_ID_PK NO ACTION
RHN_SPROFILE_NID_FKNAME_ID RHNPACKAGENAME RHN_PN_ID_PK NO ACTION
RHN_SPROFILE_PACKAGE_FKPACKAGE_ARCH_ID RHNPACKAGEARCH RHN_PARCH_ID_PK NO ACTION
RHN_SPROFILE_SPID_FKSERVER_PROFILE_ID RHNSERVERPROFILE RHN_SERVER_PROFILE_ID_PK CASCADE

Options:

OptionSettings
TablespaceUSERS
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
RHN_SPROF_SP_SNE_IDXNORMALNONUNIQUESERVER_PROFILE_ID , NAME_ID , EVR_ID DDL script