Spacewalk DB Schema - Table-RHN_URL_PROBE

Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Sanity Check Index DDL scrips

RHN_URL_PROBE_STEP

urlps url probe step

Name	Type	Nullable	Default value
RECID	NUMBER(12)	N
URL_PROBE_ID	NUMBER(12)	N
STEP_NUMBER	NUMBER(3)	N
DESCRIPTION	VARCHAR2(255)	Y
URL	VARCHAR2(2000)	N
PROTOCOL_METHOD	VARCHAR2(12)	N
VERIFY_LINKS	CHAR(1)	N	0
LOAD_SUBSIDIARY	CHAR(1)	N	0
PATTERN	VARCHAR2(255)	Y
VPATTERN	VARCHAR2(255)	Y
POST_CONTENT	VARCHAR2(4000)	Y
POST_CONTENT_TYPE	VARCHAR2(255)	Y
CONNECT_WARN	NUMBER(10,3)	N	0
CONNECT_CRIT	NUMBER(10,3)	N	0
LATENCY_WARN	NUMBER(10,3)	N	0
LATENCY_CRIT	NUMBER(10,3)	N	0
DNS_WARN	NUMBER(10,3)	N	0
DNS_CRIT	NUMBER(10,3)	N	0
TOTAL_WARN	NUMBER(10,3)	N	0
TOTAL_CRIT	NUMBER(10,3)	N	0
TRANS_WARN	NUMBER(12)	N	0
TRANS_CRIT	NUMBER(12)	N	0
THROUGH_WARN	NUMBER(12)	N	0
THROUGH_CRIT	NUMBER(12)	N	0
COOKIE_KEY	VARCHAR2(255)	Y
COOKIE_VALUE	VARCHAR2(255)	Y
COOKIE_PATH	VARCHAR2(255)	Y
COOKIE_DOMAIN	VARCHAR2(255)	Y
COOKIE_PORT	NUMBER(5)	Y
COOKIE_SECURE	CHAR(1)	N	0
COOKIE_MAXAGE	NUMBER(9)	Y

Constraint Name	Columns
RHN_URLPS_RECID_PK	RECID

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_URLPS_URLPB_URL_PR_ID_FK	URL_PROBE_ID	RHN_URL_PROBE	RHN_URLPB_PROBE_ID_PK	CASCADE

Index Name	Type	Unuqueness	Columns	DDL script
RHN_URLPS_RECID_PK	NORMAL	UNIQUE	RECID	DDL script
RHN_URLPS_URL_PR_ID_STP_N_UQ	NORMAL	UNIQUE	URL_PROBE_ID , STEP_NUMBER	DDL script