Table ESEC.ESECDBA.VULN_RSRC 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_ID VULN_RSRC_VULN_FK
VULN_CALC_SEVERITY_RPT_V.RSRC_ID Implied Constraint
VULN_RPT_V.RSRC_ID Implied Constraint
VULN_RSRC_RPT_V.RSRC_ID Implied Constraint
VULN_RSRC_SCAN.RSRC_ID VULN_RSRC_VULN_RSRC_SCAN_FK
VULN_RSRC_SCAN_RPT_V.RSRC_ID Implied Constraint
SCANNER_ID varchar2 108
VULN_SCANNER.SCANNER_ID VULN_SCANNER_VULN_RSRC_FK
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

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

Indexes:
Column(s) Type Sort Constraint Name
RSRC_ID Primary key Asc VULN_RSRC_PK
CRITICALITY Performance Asc VULN_RSRC_CRITICALITY_IDX
DEPARTMENT Performance Asc VULN_RSRC_DEPARTMENT_IDX
HOST_NAME Performance Asc VULN_RSRC_HOST_NAME
IP Performance Asc VULN_RSRC_IP_IDX
LOCATION Performance Asc VULN_RSRC_LOCATION_IDX
OPERATIONAL_ENVIRONMENT Performance Asc VULN_RSRC_OP_ENV_IDX
REGULATION Performance Asc VULN_RSRC_REGULATION_IDX
SCANNER_ID Performance Asc VULN_RSRC_SCANNER_ID_IDX

Close relationships  within of separation: