Table SIEM.public.adv_nxs_signatures
List of signatures of the products that are supported by Novell for Advisor.

 Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
product_id int4 10
adv_nxs_mappings
adv_nxs_mappings
adv_nxs_products
The unique ID of the product.
signature_id varchar 256  √  null
adv_nxs_mappings
adv_nxs_mappings
The unique ID of the signature.
signature_name varchar 256  √  null Name of the signature.
published timestamp 29,6 Time stamp indicating when the signature was published for the product by the vendor.
inserted timestamp 29,6 Time stamp indicating when the signature information was entered in the vendor database.
updated timestamp 29,6 Time stamp indicating when the signature information was updated in the vendor database.
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
product_id + signature_id Must be unique Asc/Asc
product_id + signature_id Performance Asc/Asc
product_id + signature_name Performance Asc/Asc

Close relationships: