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
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
product_id int4 10
adv_nxs_mappings.source_product_id adv_nxs_mappings_source_fkey R
adv_nxs_mappings.target_product_id adv_nxs_mappings_target_fkey R
adv_nxs_products.product_id adv_nxs_sign_product_id_fkey R
The unique ID of the product.
signature_id varchar 256  √  null
adv_nxs_mappings.source_signature_id adv_nxs_mappings_source_fkey R
adv_nxs_mappings.target_signature_id adv_nxs_mappings_target_fkey R
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 Constraint Name
product_id + signature_id Must be unique Asc/Asc adv_nxs_sign_id_ukey
product_id + signature_id Performance Asc/Asc adv_nxs_signatures_idx1
product_id + signature_name Performance Asc/Asc adv_nxs_signatures_idx2

Close relationships: