Spacewalk DB Schema - Table-RHN_REDIRECTS

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

Columns

Name	Type	Nullable	Default value	Comment
RECID	NUMBER(12)	N
CUSTOMER_ID	NUMBER(12)	Y
CONTACT_ID	NUMBER(12)	Y
REDIRECT_TYPE	VARCHAR2(20)	N
DESCRIPTION	VARCHAR2(25)	Y
REASON	VARCHAR2(2000)	Y
EXPIRATION	DATE	N
LAST_UPDATE_USER	VARCHAR2(40)	Y
LAST_UPDATE_DATE	DATE	Y
START_DATE	DATE	N
RECURRING	NUMBER(12)	N	0
RECURRING_FREQUENCY	NUMBER(12)	Y	2
RECURRING_DURATION	NUMBER(12)	Y	0
RECURRING_DUR_TYPE	NUMBER(12)	Y	12

Primary key:

Constraint Name	Columns
RHN_RDRCT_RECID_PK	RECID

Check Constraints:

Constraint Name	Check Condition
RHN_RDRCT_RECUR_FREQ_VALID	recurring_frequency in (2,3,6)
RHN_RDRCT_RECUR_VALID	recurring in (0, 1)
RHN_RDRCT_REC_DTYPE_VALID	recurring_dur_type in (12,11,5,3,1)
RHN_RDRCT_START_LTE_EXPIR	start_date <= expiration

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_RDRCT_CNTCT_CONTACT_ID_FK	CONTACT_ID	WEB_CONTACT	WEB_CONTACT_PK	NO ACTION
RHN_RDRCT_CSTMR_CUSTOMER_ID_FK	CUSTOMER_ID	WEB_CUSTOMER	WEB_CUSTOMER_ID_PK	NO ACTION
RHN_RDRCT_RDRTP_REDIR_TYPE_FK	REDIRECT_TYPE	RHN_REDIRECT_TYPES	RHN_RDRTP_NAME_PK	NO ACTION

Options:

Option	Settings
Tablespace	DATA_TBS
Index Organized	No
Generated by Oracle	No
Clustered	No
Nested	No
Temporary	No

Indexes:

Index Name	Type	Unuqueness	Columns	DDL script
RHN_RDRCT_CID_IDX	NORMAL	NONUNIQUE	CONTACT_ID	DDL script
RHN_RDRCT_CUSTOMER_ID_IDX	NORMAL	NONUNIQUE	CUSTOMER_ID	DDL script
RHN_RDRCT_RECID_PK	NORMAL	UNIQUE	RECID	DDL script
RHN_RDRCT_REDIRECT_TYPE_IDX	NORMAL	NONUNIQUE	REDIRECT_TYPE	DDL script

Referenced by:

Table	Constraint
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