View ESEC.ESECDBA.VULN_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
VULN_ID varchar2 108
VULN.VULN_ID Implied Constraint
RSRC_ID varchar2 108
VULN_RSRC.RSRC_ID Implied Constraint
PORT_NAME varchar2 192  √  null
PORT_NUMBER number 22  √  null
NETWORK_PROTOCOL number 22  √  null
APPLICATION_PROTOCOL varchar2 192  √  null
ASSIGNED_VULN_SEVERITY number 22  √  null
COMPUTED_VULN_SEVERITY number 22  √  null
VULN_DESCRIPTION clob 4000  √  null
VULN_SOLUTION clob 4000  √  null
VULN_SUMMARY varchar2 3000  √  null
BEGIN_EFFECTIVE_DATE date 7  √  null
END_EFFECTIVE_DATE date 7  √  null
DETECTED_OS varchar2 192  √  null
DETECTED_OS_VERSION varchar2 192  √  null
SCANNED_APP varchar2 192  √  null
SCANNED_APP_VERSION varchar2 192  √  null
VULN_USER_NAME varchar2 192  √  null
VULN_USER_DOMAIN varchar2 192  √  null
VULN_TAXONOMY varchar2 3000  √  null
SCANNER_CLASSIFICATION varchar2 765  √  null
VULN_NAME varchar2 900  √  null
VULN_MODULE varchar2 192  √  null
DATE_CREATED date 7
DATE_MODIFIED date 7
CREATED_BY number 22  √  null
MODIFIED_BY number 22  √  null

Analyzed at Tue May 04 17:09 EDT 2010

View SQL:
SELECT "VULN_ID","RSRC_ID","PORT_NAME","PORT_NUMBER","NETWORK_PROTOCOL","APPLICATION_PROTOCOL","ASSIGNED_VULN_SEVERITY","COMPUTED_VULN_SEVERITY","VULN_DESCRIPTION","VULN_SOLUTION","VULN_SUMMARY","BEGIN_EFFECTIVE_DATE","END_EFFECTIVE_DATE","DETECTED_OS","DETECTED_OS_VERSION","SCANNED_APP","SCANNED_APP_VERSION","VULN_USER_NAME","VULN_USER_DOMAIN","VULN_TAXONOMY","SCANNER_CLASSIFICATION","VULN_NAME","VULN_MODULE","DATE_CREATED","DATE_MODIFIED","CREATED_BY","MODIFIED_BY" FROM VULN

Close relationships: