View SIEM.public.adv_nxs_mappings_v
The mapping between each product such as IDS product signature, Vulnerability product signatures etc.

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
source_product_id int4 10  √  null The unique ID of the source product.
source_signature_id varchar 256  √  null The unique ID of the source signature.
target_product_id int4 10  √  null The unique ID of the target product.
target_signature_id varchar 256  √  null The unique ID of the target signature.
mapping_direct bool 1  √  null TRUE indicates that the mapping is direct.
mapping_indirect bool 1  √  null TRUE indicates that the mapping is indirect.
mapping_ngram bool 1  √  null TRUE indicates that the mapping is n-gram.
inserted timestamp 29,6  √  null Time stamp indicating when the mapping information was entered in the vendor database.
updated timestamp 29,6  √  null Time stamp indicating when the mapping was updated in the vendor database.
is_deleted bool 1  √  null TRUE indicates that the mapping is marked as invalid.
deleted timestamp 29,6  √  null Time stamp indicating when the mapping was marked as invalid.
date_created timestamp 29,6  √  null Date the entry was created
date_modified timestamp 29,6  √  null Date the entry was modified
created_by int4 10  √  null User who created object
modified_by int4 10  √  null User who last modified object

Analyzed at Mon Mar 26 23:24 EDT 2012