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_METRICS

Description:

metrc metric definitions

DDL script

Columns

NameTypeNullableDefault valueComment
METRIC_IDVARCHAR2(40)N  
STORAGE_UNIT_IDVARCHAR2(10)N  
DESCRIPTIONVARCHAR2(200)Y  
LAST_UPDATE_USERVARCHAR2(40)Y  
LAST_UPDATE_DATEDATEY  
LABELVARCHAR2(40)Y  
COMMAND_CLASSVARCHAR2(255)N'nothing'  

Primary key:

Constraint NameColumns
RHN_METRC_CMD_CL_METRIC_ID_PKCOMMAND_CLASS , METRIC_ID

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
RHN_METRC_COMCL_CMD_CLASS_FKCOMMAND_CLASS RHN_COMMAND_CLASS RHN_COMCL_CLASS_NAME_PK NO ACTION
RHN_METRC_UTS_STOR_UT_ID_FKSTORAGE_UNIT_ID RHN_UNITS RHN_UNITS_UNIT_ID_PK NO ACTION

Options:

OptionSettings
TablespaceDATA_TBS
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
RHN_METRC_CMD_CL_MET_ID_PKNORMALUNIQUECOMMAND_CLASS , METRIC_ID DDL script
RHN_METRC_STORAGE_UNIT_ID_IDXNORMALNONUNIQUESTORAGE_UNIT_ID DDL script

Referenced by:

TableConstraint
RHN_COMMAND_PARAM_THRESHOLD RHN_COPTR_M_THR_M_CMD_CL_FK
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Fri Jun 13 14:06:24 2008