Spacewalk DB Schema - Table-RHN_SERVICE_PROBE

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_SERVICE_PROBE_ORIGINS

Description:

srvpo mapping from a replicated service probe to the check suite probe it was copied from. uq instead of pk because need to set origin_probe_id to null!!!

DDL script

Columns

Name	Type	Nullable	Default value
SERVICE_PROBE_ID	NUMBER(12)	N
ORIGIN_PROBE_ID	NUMBER(12)	Y
DECOUPLED	CHAR(1)	N	'0'

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_SRVPO_CHKPB_ORIG_PR_ID_FK	ORIGIN_PROBE_ID	RHN_CHECK_SUITE_PROBE	RHN_CKSPB_PROBE_ID_PK	CASCADE
RHN_SRVPO_PR_SERV_PR_FK	SERVICE_PROBE_ID	RHN_PROBE	RHN_PROBE_RECID_PK	CASCADE

Unique Keys:

Constraint name	Columns
RHN_SRVPO_SERV_PR_ID_ORIG_UQ	SERVICE_PROBE_ID , ORIGIN_PROBE_ID

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_SRVPO_SERV_ORIG_PR_ID_UQ	NORMAL	UNIQUE	ORIGIN_PROBE_ID , SERVICE_PROBE_ID	DDL script
RHN_SRVPO_SERV_PR_ID_ORIG_UQ	NORMAL	UNIQUE	SERVICE_PROBE_ID , ORIGIN_PROBE_ID	DDL script