Spacewalk DB Schema - Table-RHN_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_PROBE

Description:

probe probe definitions

Columns

Name	Type	Nullable	Default value	Comment
RECID	NUMBER(12)	N
PROBE_TYPE	VARCHAR2(15)	N
DESCRIPTION	VARCHAR2(255)	N
CUSTOMER_ID	NUMBER(12)	N
COMMAND_ID	NUMBER(16)	N
CONTACT_GROUP_ID	NUMBER(12)	Y
NOTIFY_CRITICAL	CHAR(1)	Y
NOTIFY_WARNING	CHAR(1)	Y
NOTIFY_UNKNOWN	CHAR(1)	Y
NOTIFY_RECOVERY	CHAR(1)	Y
NOTIFICATION_INTERVAL_MINUTES	NUMBER(16)	N
CHECK_INTERVAL_MINUTES	NUMBER(16)	N
RETRY_INTERVAL_MINUTES	NUMBER(16)	N
MAX_ATTEMPTS	NUMBER(16)	Y
LAST_UPDATE_USER	VARCHAR2(40)	Y
LAST_UPDATE_DATE	DATE	Y

Primary key:

Constraint Name	Columns
RHN_PROBE_RECID_PK	RECID

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_PROBE_CMMND_COMMAND_ID_FK	COMMAND_ID	RHN_COMMAND	RHN_CMMND_RECID_PK	NO ACTION
RHN_PROBE_CSTMR_CUSTOMER_ID_FK	CUSTOMER_ID	WEB_CUSTOMER	WEB_CUSTOMER_ID_PK	NO ACTION
RHN_PROBE_PRBTP_PROBE_TYPE_FK	PROBE_TYPE	RHN_PROBE_TYPES	RHN_PRBTP_PROBE_TYPE_PK	NO ACTION

Unique Keys:

Constraint name	Columns
RHN_PROBE_RECID_PROBE_TYPE_UQ	RECID , PROBE_TYPE

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_PROBE_CHECK_COMMAND_ID_IDX	NORMAL	NONUNIQUE	COMMAND_ID	DDL script
RHN_PROBE_CONTACT_GRP_IDX	NORMAL	NONUNIQUE	CONTACT_GROUP_ID	DDL script
RHN_PROBE_CUSTOMER_ID_IDX	NORMAL	NONUNIQUE	CUSTOMER_ID	DDL script
RHN_PROBE_PROBE_TYPE_IDX	NORMAL	NONUNIQUE	PROBE_TYPE	DDL script
RHN_PROBE_RECID_PK	NORMAL	UNIQUE	RECID	DDL script
RHN_PROBE_RECID_PROBE_TYPE_UQ	NORMAL	UNIQUE	RECID , PROBE_TYPE	DDL script

Referenced by:

Table	Constraint
RHN_CHECK_PROBE	RHN_CHKPB_RECID_PROBE_TYP_FK
RHN_HOST_PROBE	RHN_HSTPB_PROBE_PROBE_ID_FK
RHN_PROBE_PARAM_VALUE	RHN_PPVAL_CHKPB_PROBE_ID_FK
RHN_SAT_CLUSTER_PROBE	RHN_SCLPB_PRB_RECID_PRB_TYP_FK
RHN_SAT_NODE_PROBE	RHN_SNDPB_PR_RECID_PR_TYP_FK
RHN_SERVICE_PROBE_ORIGINS	RHN_SRVPO_PR_SERV_PR_FK
RHN_URL_PROBE	RHN_URLPB_PROBE_PR_ID_PR_FK