Table ESEC.ESECDBA.EVT_DEST_EVT_NAME_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
EVT_NAME_ID number 22
EVT_NAME.EVT_NAME_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 + EVT_NAME_ID + SEV + XDAS_TXNMY_ID + CUST_ID Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc EVT_DEST_EVT_NAME_SMRY_1_UK1

Close relationships: