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

RHNACTIONTRANSACTIONS

DDL script

Columns

NameTypeNullableDefault valueComment
ACTION_IDNUMBER(38)N  
FROM_TRANS_IDNUMBER(38)N  
TO_TRANS_IDNUMBER(38)N  

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
RHN_AT_AID_FKACTION_ID RHNACTION RHN_ACTION_PK CASCADE
RHN_AT_FTID_FKFROM_TRANS_ID RHNTRANSACTION RHN_TRANS_ID_PK CASCADE
RHN_AT_TTID_FKTO_TRANS_ID RHNTRANSACTION RHN_TRANS_ID_PK CASCADE

Options:

OptionSettings
TablespaceDATA_TBS
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
RHN_ACT_TRANS_FROM_TO_IDXNORMALNONUNIQUEFROM_TRANS_ID , TO_TRANS_ID , ACTION_ID DDL script
RHN_ACT_TRANS_TO_FROM_IDXNORMALNONUNIQUETO_TRANS_ID , FROM_TRANS_ID , ACTION_ID DDL script
RHN_AT_AID_FTID_TTID_UQNORMALUNIQUEACTION_ID , FROM_TRANS_ID , TO_TRANS_ID DDL script
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Fri Jun 13 14:06:17 2008