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_PARAM_THRESHOLD

Description:

coptr a parameter for a particular command

DDL script

Columns

NameTypeNullableDefault valueComment
COMMAND_IDNUMBER(12)N  
PARAM_NAMEVARCHAR2(40)N  
PARAM_TYPEVARCHAR2(10)N  
THRESHOLD_TYPE_NAMEVARCHAR2(10)N  
THRESHOLD_METRIC_IDVARCHAR2(40)N  
LAST_UPDATE_USERVARCHAR2(40)Y  
LAST_UPDATE_DATEDATEY  
COMMAND_CLASSVARCHAR2(255)N  

Primary key:

Constraint NameColumns
RHN_COPTR_ID_P_NAME_P_TYPE_PKCOMMAND_ID , PARAM_NAME , PARAM_TYPE

Check Constraints:

Constraint NameCheck Condition
RHN_COPTR_PARAM_TYPE_CKparam_type='threshold'

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
RHN_COPTR_CMD_ID_CMD_CL_FKCOMMAND_ID , COMMAND_CLASS RHN_COMMAND RHN_CMMND_NAME_UQ CASCADE
RHN_COPTR_M_THR_M_CMD_CL_FKCOMMAND_CLASS , THRESHOLD_METRIC_ID RHN_METRICS RHN_METRC_CMD_CL_METRIC_ID_PK CASCADE
RHN_COPTR_THRTP_THRES_TYPE_FKTHRESHOLD_TYPE_NAME RHN_THRESHOLD_TYPE RHN_TRTYP_NAME_PK NO ACTION

Options:

OptionSettings
TablespaceDATA_TBS
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

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