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_REDIRECTS

Description:

rdrct redirect definitions

DDL script

Columns

NameTypeNullableDefault valueComment
RECIDNUMBER(12)N  
CUSTOMER_IDNUMBER(12)Y  
CONTACT_IDNUMBER(12)Y  
REDIRECT_TYPEVARCHAR2(20)N  
DESCRIPTIONVARCHAR2(25)Y  
REASONVARCHAR2(2000)Y  
EXPIRATIONDATEN  
LAST_UPDATE_USERVARCHAR2(40)Y  
LAST_UPDATE_DATEDATEY  
START_DATEDATEN  
RECURRINGNUMBER(12)N0  
RECURRING_FREQUENCYNUMBER(12)Y2  
RECURRING_DURATIONNUMBER(12)Y0 
RECURRING_DUR_TYPENUMBER(12)Y12  

Primary key:

Constraint NameColumns
RHN_RDRCT_RECID_PKRECID

Check Constraints:

Constraint NameCheck Condition
RHN_RDRCT_RECUR_FREQ_VALIDrecurring_frequency in (2,3,6)
RHN_RDRCT_RECUR_VALIDrecurring in (0, 1)
RHN_RDRCT_REC_DTYPE_VALID recurring_dur_type in (12,11,5,3,1)
RHN_RDRCT_START_LTE_EXPIRstart_date <= expiration

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
RHN_RDRCT_CNTCT_CONTACT_ID_FKCONTACT_ID WEB_CONTACT WEB_CONTACT_PK NO ACTION
RHN_RDRCT_CSTMR_CUSTOMER_ID_FKCUSTOMER_ID WEB_CUSTOMER WEB_CUSTOMER_ID_PK NO ACTION
RHN_RDRCT_RDRTP_REDIR_TYPE_FKREDIRECT_TYPE RHN_REDIRECT_TYPES RHN_RDRTP_NAME_PK NO ACTION

Options:

OptionSettings
TablespaceDATA_TBS
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
RHN_RDRCT_CID_IDXNORMALNONUNIQUECONTACT_ID DDL script
RHN_RDRCT_CUSTOMER_ID_IDXNORMALNONUNIQUECUSTOMER_ID DDL script
RHN_RDRCT_RECID_PKNORMALUNIQUERECID DDL script
RHN_RDRCT_REDIRECT_TYPE_IDXNORMALNONUNIQUEREDIRECT_TYPE DDL script

Referenced by:

TableConstraint
RHN_REDIRECT_CRITERIA RHN_RDRCR_RDRCT_REDIRECT_ID_FK
RHN_REDIRECT_EMAIL_TARGETS RHN_RDRET_RDRCT_REDIRECT_ID_FK
RHN_REDIRECT_GROUP_TARGETS RHN_RDRGT_RDRCT_REDIRECT_ID_FK
RHN_REDIRECT_METHOD_TARGETS RHN_RDRMT_RDRCT_REDIRECT_ID_FK