View ESEC.ESECDBA.VULN_RSRC_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
RSRC_ID varchar2 108
VULN_RSRC.RSRC_ID Implied Constraint
SCANNER_ID varchar2 108
VULN_SCANNER.SCANNER_ID Implied Constraint
IP varchar2 96
HOST_NAME varchar2 765  √  null
LOCATION varchar2 384  √  null
DEPARTMENT varchar2 384  √  null
BUSINESS_SYSTEM varchar2 384  √  null
OPERATIONAL_ENVIRONMENT varchar2 192  √  null
CRITICALITY number 22  √  null
REGULATION varchar2 384  √  null
REGULATION_RATING 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 "RSRC_ID","SCANNER_ID","IP","HOST_NAME","LOCATION","DEPARTMENT","BUSINESS_SYSTEM","OPERATIONAL_ENVIRONMENT","CRITICALITY","REGULATION","REGULATION_RATING","DATE_CREATED","DATE_MODIFIED","CREATED_BY","MODIFIED_BY" FROM VULN_RSRC

Close relationships: