Spacewalk DB Schema - Table-RHN_STRATEGIES

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_STRATEGIES

Description:

strat strategy definitions

Columns

Name	Type	Nullable	Default value	Comment
RECID	NUMBER(12)	N
NAME	VARCHAR2(80)	Y
COMP_CRIT	VARCHAR2(80)	Y
ESC_CRIT	VARCHAR2(80)	Y
CONTACT_STRATEGY	VARCHAR2(32)	Y
ACK_COMPLETED	VARCHAR2(32)	Y

Primary key:

Constraint Name	Columns
RHN_STRAT_RECID_PK	RECID

Check Constraints:

Constraint Name	Check Condition
RHN_STRAT_ACK_COMP_CK	ack_completed in ( 'All', 'One','No' )
RHN_STRAT_CONT_STRAT_CK	contact_strategy in ('Broadcast','Escalate')
RHN_STRAT_RECID_CK	recid > 0

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_STRAT_RECID_PK	NORMAL	UNIQUE	RECID	DDL script

Referenced by:

Table	Constraint
RHN_CONTACT_GROUPS	RHN_CNTGP_STRAT_STRATEGY_ID_FK