Table ESEC.ESECDBA.EVT_DEST_TXNMY_SMRY_1 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
DEST_IP number 22
DEST_EVT_ASSET_ID number 22
TXNMY_ID number 22
EVT_TXNMY.TXNMY_ID Implied Constraint
SEV number 22
CUST_ID number 22
CUST.CUST_ID Implied Constraint
EVT_TIME date 7
XDAS_TXNMY_ID number 22
EVT_XDAS_TXNMY.XDAS_TXNMY_ID Implied Constraint
EVT_CNT number 22  √  null
DATE_CREATED date 7  √  null
DATE_MODIFIED date 7  √  null
CREATED_BY number 22  √  null
MODIFIED_BY number 22  √  null
DHN varchar2 765  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
EVT_TIME + DEST_IP + DHN + DEST_EVT_ASSET_ID + TXNMY_ID + SEV + XDAS_TXNMY_ID + CUST_ID Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc EVT_DEST_TXNMY_SMRY_1_UK1

Close relationships: