View ESEC.ESECDBA.EVT_SRC_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
SOURCE_IP number 22
SOURCE_EVENT_ASSET_ID number 22
SOURCE_PORT varchar2 96
SOURCE_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
INIT_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
SOURCE_HOST_NAME varchar2 765  √  null

Analyzed at Tue May 04 17:09 EDT 2010

View SQL:
SELECT
SRC_IP as Source_IP,
SRC_EVT_ASSET_ID as Source_Event_Asset_ID,
SRC_PORT as Source_Port,
SRC_USR_ID as Source_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,
INIT_USR_IDENTITY_GUID as Init_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,
SHN as Source_Host_Name
FROM EVT_SRC_SMRY_1

Close relationships: