Spacewalk DB Schema - Table-RHN_COMMAND_PARAMETER

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_PARAMETER

Description:

CPARM A parameter for a particular command

Columns

Name	Type	Nullable	Default value	Comment
COMMAND_ID	NUMBER(12)	N
PARAM_NAME	VARCHAR2(40)	N
PARAM_TYPE	VARCHAR2(10)	N	'config'
DATA_TYPE_NAME	VARCHAR2(10)	N
DESCRIPTION	VARCHAR2(80)	N
MANDATORY	CHAR(1)	N	'0'
DEFAULT_VALUE	VARCHAR2(1024)	Y
MIN_VALUE	NUMBER(38)	Y
MAX_VALUE	NUMBER(38)	Y
FIELD_ORDER	NUMBER(38)	N
FIELD_WIDGET_NAME	VARCHAR2(20)	N
FIELD_VISIBLE_LENGTH	NUMBER(38)	Y
FIELD_MAXIMUM_LENGTH	NUMBER(38)	Y
FIELD_VISIBLE	CHAR(1)	N	'1'	if default is $HOSTADDRESS$, param is marked as default not visible
DEFAULT_VALUE_VISIBLE	CHAR(1)	N	'1'
LAST_UPDATE_USER	VARCHAR2(40)	Y
LAST_UPDATE_DATE	DATE	Y

Primary key:

Constraint Name	Columns
RHN_CPARM_ID_PARM_NAME_PK	COMMAND_ID , PARAM_NAME

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_CPARM_CMD_COMMAND_ID_FK	COMMAND_ID	RHN_COMMAND	RHN_CMMND_RECID_PK	CASCADE
RHN_CPARM_SDTYP_NAME_FK	DATA_TYPE_NAME	RHN_SEMANTIC_DATA_TYPE	RHN_SDTYP_NAME_PK	NO ACTION
RHN_CPARM_WDGT_FLD_WDGT_N_FK	FIELD_WIDGET_NAME	RHN_WIDGET	RHN_WDGET_NAME_PK	NO ACTION

Unique Keys:

Constraint name	Columns
RHN_CPARM_ID_FIELD_ORDE_UQ	COMMAND_ID , FIELD_ORDER
RHN_CPARM_ID_P_NAME_P_TYPE_UQ	COMMAND_ID , PARAM_NAME , PARAM_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_CPARM_CMD_ID_FIELD_ORDE_UQ	NORMAL	UNIQUE	COMMAND_ID , FIELD_ORDER	DDL script
RHN_CPARM_CMD_ID_PARAM_NAME_UQ	NORMAL	UNIQUE	COMMAND_ID , PARAM_NAME	DDL script
RHN_CPARM_ID_P_NAME_P_TYPE_UQ	NORMAL	UNIQUE	COMMAND_ID , PARAM_NAME , PARAM_TYPE	DDL script

Referenced by:

Table	Constraint
RHN_PROBE_PARAM_VALUE	RHN_PPVAL_CMD_ID_PARM_NM_FK