Spacewalk DB Schema - Table-RHN_COMMAND

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

Description:

CMMND A command that probes can run

Columns

Name	Type	Nullable	Default value	Comment
RECID	NUMBER(12)	N
NAME	VARCHAR2(40)	N
DESCRIPTION	VARCHAR2(80)	N
GROUP_NAME	VARCHAR2(40)	Y
ALLOWED_IN_SUITE	CHAR(1)	N	'1'
COMMAND_CLASS	VARCHAR2(255)	N	'/home/nocpulse/libexec/plugin'	Program to run
ENABLED	CHAR(1)	N	'1'	Whether command should be usable
FOR_HOST_PROBE	CHAR(1)	N	'0'	Whether this is one of the host-alive checks
LAST_UPDATE_USER	VARCHAR2(40)	Y
LAST_UPDATE_DATE	DATE	Y
SYSTEM_REQUIREMENTS	VARCHAR2(40)	Y
VERSION_SUPPORT	VARCHAR2(1024)	Y
HELP_URL	VARCHAR2(1024)	Y

Primary key:

Constraint Name	Columns
RHN_CMMND_RECID_PK	RECID

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_CMMND_CMDGR_GROUP_NAME_FK	GROUP_NAME	RHN_COMMAND_GROUPS	RHN_CMDGR_GROUP_NAME_PK	NO ACTION
RHN_CMMND_COMCL_CLASS_NAME_FK	COMMAND_CLASS	RHN_COMMAND_CLASS	RHN_COMCL_CLASS_NAME_PK	NO ACTION
RHN_CMMND_SYS_REQS_FK	SYSTEM_REQUIREMENTS	RHN_COMMAND_REQUIREMENTS	RHN_CREQS_NAME_PK	CASCADE

Unique Keys:

Constraint name	Columns
RHN_CMMND_NAME_UQ	RECID , COMMAND_CLASS

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_CMMND_NAME_UQ	NORMAL	UNIQUE	NAME	DDL script
RHN_CMMND_RECID_COMM_CL_UQ	NORMAL	UNIQUE	RECID , COMMAND_CLASS	DDL script
RHN_CMMND_RECID_PK	NORMAL	UNIQUE	RECID	DDL script

Referenced by:

Table	Constraint
RHN_COMMAND_PARAM_THRESHOLD	RHN_COPTR_CMD_ID_CMD_CL_FK
RHN_COMMAND_PARAMETER	RHN_CPARM_CMD_COMMAND_ID_FK
RHN_OS_COMMANDS_XREF	RHN_OSCXR_CMMND_COMMANDS_ID_FK
RHN_PROBE	RHN_PROBE_CMMND_COMMAND_ID_FK