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_PROBE_PARAM_VALUE

Description:

ppval param value for a probe running a command

DDL script

Columns

NameTypeNullableDefault valueComment
PROBE_IDNUMBER(38)N  
COMMAND_IDNUMBER(38)N  
PARAM_NAMEVARCHAR2(40)N  
VALUEVARCHAR2(1024)Y  
LAST_UPDATE_USERVARCHAR2(40)Y  
LAST_UPDATE_DATEDATEY  

Primary key:

Constraint NameColumns
RHN_PPVAL_P_ID_CMD_ID_PARM_PKPROBE_ID , COMMAND_ID , PARAM_NAME

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
RHN_PPVAL_CHKPB_PROBE_ID_FKPROBE_ID RHN_PROBE RHN_PROBE_RECID_PK CASCADE
RHN_PPVAL_CMD_ID_PARM_NM_FKCOMMAND_ID , PARAM_NAME RHN_COMMAND_PARAMETER RHN_CPARM_ID_PARM_NAME_PK CASCADE

Options:

OptionSettings
TablespaceDATA_TBS
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
RHN_PPVAL_P_ID_CMD_ID_PARM_PKNORMALUNIQUEPROBE_ID , COMMAND_ID , PARAM_NAME DDL script
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Fri Jun 13 14:06:24 2008