Table ESEC.ESECDBA.VULN 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
INCIDENTS_VULN.VULN_ID Implied Constraint
INCIDENTS_VULN_RPT_V.VULN_ID Implied Constraint
VULN_CODE.VULN_ID VULN_VULN_CODE_FK
VULN_CODE_RPT_V.VULN_ID Implied Constraint
VULN_INFO.VULN_ID VULN_VULN_INFO_FK
VULN_INFO_RPT_V.VULN_ID Implied Constraint
VULN_RPT_V.VULN_ID Implied Constraint
VULN_SCAN_VULN.VULN_ID VULN_VULN_SCAN_VULN_FK
VULN_SCAN_VULN_RPT_V.VULN_ID Implied Constraint
RSRC_ID varchar2 108
VULN_RSRC.RSRC_ID VULN_RSRC_VULN_FK
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

Table contained 280 rows at Tue May 04 17:09 EDT 2010

Indexes:
Column(s) Type Sort Constraint Name
VULN_ID Primary key Asc VULN_PK
END_EFFECTIVE_DATE + BEGIN_EFFECTIVE_DATE Performance Asc/Asc VULN_END_BEGIN_EFF_DATE_IDX
PORT_NUMBER + NETWORK_PROTOCOL + RSRC_ID Performance Asc/Asc/Asc VULN_PORT_PROTOCOL_RSRC_IDX
RSRC_ID Performance Asc VULN_RSRC_ID_IDX

Close relationships  within of separation: