Spacewalk DB Schema - Table-RHNTASKORUN

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

Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers Partitions

RHNTASKORUN

Columns

Name	Type	Nullable	Default value	Comment
ID	NUMBER(38)	N
TEMPLATE_ID	NUMBER(38)	N
SCHEDULE_ID	NUMBER(38)	N
ORG_ID	NUMBER(38)	Y
START_TIME	TIMESTAMP(6) WITH LOCAL TIME ZONE	Y
END_TIME	TIMESTAMP(6) WITH LOCAL TIME ZONE	Y
STD_OUTPUT_PATH	VARCHAR2(100)	Y
STD_ERROR_PATH	VARCHAR2(100)	Y
STATUS	VARCHAR2(12)	Y
CREATED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)
MODIFIED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)

Primary key:

Constraint Name	Columns
RHN_TASKO_RUN_ID_PK	ID

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_TASKO_RUN_SCHEDULE_FK	SCHEDULE_ID	RHNTASKOSCHEDULE	RHN_TASKO_SCHEDULE_ID_PK	CASCADE
RHN_TASKO_RUN_TEMPLATE_FK	TEMPLATE_ID	RHNTASKOTEMPLATE	RHN_TASKO_TEMPLATE_ID_PK	NO ACTION

Options:

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

Indexes:

Index Name	Type	Unuqueness	Columns	DDL script
RHN_TASKO_RUN_ID_PK	NORMAL	UNIQUE	ID	DDL script