Spacewalk DB Schema - Table-RHN_COMMAND_QUEUE_EXECS

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_COMMAND_QUEUE_EXECS

Description:

cqexe command queue execution records

Columns

Name	Type	Nullable	Default value	Comment
INSTANCE_ID	NUMBER(12)	N
NETSAINT_ID	NUMBER(12)	N
DATE_ACCEPTED	DATE	Y
DATE_EXECUTED	DATE	Y
EXIT_STATUS	NUMBER(5)	Y
EXECUTION_TIME	NUMBER(10,6)	Y
STDOUT	VARCHAR2(4000)	Y
STDERR	VARCHAR2(4000)	Y
LAST_UPDATE_DATE	DATE	Y
TARGET_TYPE	VARCHAR2(10)	N

Primary key:

Constraint Name	Columns
RHN_CQEXE_INST_ID_NSAINT_PK	INSTANCE_ID , NETSAINT_ID

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_CQEXE_CQINS_INST_ID_FK	INSTANCE_ID	RHN_COMMAND_QUEUE_INSTANCES	RHN_CQINS_RECID_PK	CASCADE
RHN_CQEXE_SATCL_NSAINT_ID_FK	NETSAINT_ID , TARGET_TYPE	RHN_COMMAND_TARGET	RHN_CMDTG_RECID_TARGET_TYPE_PK	CASCADE

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_COMMAND_QUEUE_NETSAINT_IDX	NORMAL	NONUNIQUE	NETSAINT_ID	DDL script
RHN_CQEXE_DATE_EXECUTED_IDX	NORMAL	NONUNIQUE	DATE_EXECUTED	DDL script
RHN_CQEXE_INSTANCE_ID_IDX	NORMAL	NONUNIQUE	INSTANCE_ID	DDL script
RHN_CQEXE_INST_ID_NSAINT_PK	NORMAL	UNIQUE	INSTANCE_ID , NETSAINT_ID	DDL script