View ESEC.ESECDBA.EVT_DEST_TXNMY_SMRY_1_RPT_V 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
DESTINATION_IP number 22
DESTINATION_EVENT_ASSET_ID number 22
TAXONOMY_ID number 22
SEVERITY number 22
CUST_ID number 22
CUST.CUST_ID Implied Constraint
EVENT_TIME date 7
XDAS_TAXONOMY_ID number 22
EVENT_COUNT number 22  √  null
DATE_CREATED date 7  √  null
DATE_MODIFIED date 7  √  null
CREATED_BY number 22  √  null
MODIFIED_BY number 22  √  null
DESTINATION_HOST_NAME varchar2 765  √  null

Analyzed at Tue May 04 17:09 EDT 2010

View SQL:
SELECT
DEST_IP as Destination_IP,
DEST_EVT_ASSET_ID as Destination_Event_Asset_ID,
TXNMY_ID as Taxonomy_ID,
SEV as Severity,
CUST_ID,
EVT_TIME as Event_Time,
XDAS_TXNMY_ID as XDAS_Taxonomy_id,
EVT_CNT as Event_Count,
DATE_CREATED as Date_Created,
DATE_MODIFIED as Date_Modified,
CREATED_BY as Created_By,
MODIFIED_BY as Modified_By,
DHN as Destination_Host_Name
FROM EVT_DEST_TXNMY_SMRY_1

Close relationships: