View ESEC.ESECDBA.EVT_DEST_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
DESTINATION_PORT varchar2 96
DESTINATION_USER_ID number 22
TAXONOMY_ID number 22
EVENT_NAME_ID number 22
RESOURCE_ID number 22
AGENT_ID number 22
EVT_AGENT.AGENT_ID Implied Constraint
PROTOCOL_ID number 22
SEVERITY number 22
CUST_ID number 22
CUST.CUST_ID Implied Constraint
EVENT_TIME date 7
XDAS_TAXONOMY_ID number 22
TARGET_USER_IDENTITY varchar2 108
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,
DEST_PORT as Destination_Port,
DEST_USR_ID as Destination_User_ID,
TXNMY_ID as Taxonomy_ID,
EVT_NAME_ID as Event_Name_ID,
RSRC_ID as Resource_ID,
AGENT_ID as Agent_ID,
PRTCL_ID as Protocol_ID,
SEV as Severity,
CUST_ID,
EVT_TIME as Event_Time,
XDAS_TXNMY_ID as XDAS_Taxonomy_id,
TRGT_USR_IDENTITY_GUID as Target_User_Identity,
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_SMRY_1

Close relationships: