SchemaSpy - View ESEC.ESECDBA.ADV_VULN_SIGNATURES

Generated by
SchemaSpy

Legend:

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_KEY	number	22
VULN_SCANNER_NAME	varchar2	384	√		null
VULN_NAME	varchar2	768	√		null
VULN_ID	varchar2	768	√		null

Analyzed at Tue May 04 17:09 EDT 2010

View SQL:

SELECT ADV_ATTACK_PLUGIN.PLUGIN_KEY, ADV_PRODUCT.PRODUCT_NAME, ADV_ATTACK_PLUGIN.PLUGIN_NAME, ADV_ATTACK_PLUGIN.PLUGIN_ID
FROM ADV_PRODUCT, ADV_ATTACK_PLUGIN, ADV_PRODUCT_VERSION, ADV_PRODUCT_SERVICE_PACK
WHERE ADV_PRODUCT_SERVICE_PACK.SERVICE_PACK_ID = ADV_ATTACK_PLUGIN.SERVICE_PACK_ID
AND ADV_PRODUCT_SERVICE_PACK.VERSION_ID = ADV_PRODUCT_VERSION.VERSION_ID
AND ADV_PRODUCT_VERSION.PRODUCT_ID = ADV_PRODUCT.PRODUCT_ID