Table SIEM.public.txnmy_node
(Deprecated) Data for all of the nodes in the hierarchical taxonomy tree. The XDAS taxonomy is now used instead of this data structure.

 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
node_id varchar 36 Taxanomy Node identifier
node_name varchar 255 Taxanomy Node name
node_owner varchar 255 Taxanomy Node owner
node_desc varchar 1000  √  null Taxanomy Node description
created_by int4 10  √  null User who created object
modified_by int4 10  √  null User who last modified object
date_created timestamptz 35,6 Date the entry was created
date_modified timestamptz 35,6 Date the entry was modified

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

Indexes:
Column(s) Type Sort Constraint Name
node_id Primary key Asc txnmy_node_pk
node_owner + node_name Performance Asc/Asc txnmy_node_ix1