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

RHN_REDIRECT_METHOD_TARGETS

Description:

rdrme redirect method targets

DDL script

Columns

NameTypeNullableDefault valueComment
REDIRECT_IDNUMBER(12)N  
CONTACT_METHOD_IDNUMBER(12)N  

Primary key:

Constraint NameColumns
RHN_RDRME_PKREDIRECT_ID , CONTACT_METHOD_ID

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
RHN_RDRMT_CMETH_REDIRECT_ID_FKCONTACT_METHOD_ID RHN_CONTACT_METHODS RHN_CMETH_RECID_PK CASCADE
RHN_RDRMT_RDRCT_REDIRECT_ID_FKREDIRECT_ID RHN_REDIRECTS RHN_RDRCT_RECID_PK CASCADE

Options:

OptionSettings
TablespaceDATA_TBS
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
RHN_RDRME_CMID_IDXNORMALNONUNIQUECONTACT_METHOD_ID DDL script
RHN_RDRME_PKNORMALUNIQUEREDIRECT_ID , CONTACT_METHOD_ID DDL script
RHN_RDRME_REDIRECT_ID_IDXNORMALNONUNIQUEREDIRECT_ID DDL script
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Fri Jun 13 14:06:24 2008