View ESEC.ESECDBA.EVT_PORT_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_PORT varchar2 96
SEVERITY number 22
CUST_ID number 22
CUST.CUST_ID Implied Constraint
EVENT_TIME date 7
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

Analyzed at Tue May 04 17:09 EDT 2010

View SQL:
SELECT
DEST_PORT as Destination_Port,
SEV as Severity,
CUST_ID,
EVT_TIME as Event_Time,
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
FROM EVT_PORT_SMRY_1

Close relationships: