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

Table contained 0 rows at Mon Mar 26 23:24 EDT 2012

Indexes:
Column(s) Type Sort Constraint Name
source_product_id + source_signature_id Performance Asc/Asc adv_nxs_mappings_idx1

Close relationships  within of separation: