Table ESEC.ESECDBA.EVT_DEST_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
DEST_PORT varchar2 96
DEST_USR_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
RSRC_ID number 22
EVT_RSRC.RSRC_ID Implied Constraint
AGENT_ID number 22
EVT_AGENT.AGENT_ID Implied Constraint
PRTCL_ID number 22
EVT_PRTCL.PRTCL_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
TRGT_USR_IDENTITY_GUID varchar2 108
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 45,667 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 + DEST_PORT + DEST_USR_ID + TXNMY_ID + EVT_NAME_ID + RSRC_ID + AGENT_ID + PRTCL_ID + SEV + XDAS_TXNMY_ID + TRGT_USR_IDENTITY_GUID + CUST_ID Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc EVT_DEST_SMRY_1_UK1

Close relationships: