Table ESEC.ESECDBA.EVT_TXNMY Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
TXNMY_ID number 22
EVENTS.TXNMY_ID Implied Constraint
EVENTS_SUB.TXNMY_ID Implied Constraint
EVT_DEST_EVT_NAME_SMRY_1.TXNMY_ID Implied Constraint
EVT_DEST_SMRY_1.TXNMY_ID Implied Constraint
EVT_DEST_TXNMY_SMRY_1.TXNMY_ID Implied Constraint
EVT_SRC_SMRY_1.TXNMY_ID Implied Constraint
TXNMY_LVL_1 varchar2 300  √  null
TXNMY_LVL_2 varchar2 300  √  null
TXNMY_LVL_3 varchar2 300  √  null
TXNMY_LVL_4 varchar2 300  √  null
DEVICE_CTGRY varchar2 765  √  null
DATE_CREATED date 7  √  null
DATE_MODIFIED date 7  √  null
CREATED_BY number 22  √  null
MODIFIED_BY number 22  √  null

Table contained 134 rows at Tue May 04 17:09 EDT 2010

Indexes:
Column(s) Type Sort Constraint Name Anomalies
TXNMY_ID Primary key Asc EVT_TXNMY_PK  
TXNMY_LVL_1 + TXNMY_LVL_2 + TXNMY_LVL_3 + TXNMY_LVL_4 + DEVICE_CTGRY Must be unique Asc/Asc/Asc/Asc/Asc EVT_TXNMY_AK1 These unique columns are also nullable

Close relationships: