Table SIEM.public.associations
A table used for associating objects in various tables (such as users to incident, incident to annotations, 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
table1 varchar 64 Table name 1. For example, incidents
id1 int4 10 ID1. For example, incident ID.
table2 varchar 64 Table name 2. For example, users.
id2 int4 10 ID2. For example, user ID.
date_created timestamptz 35,6 Date the entry was created
date_modified timestamptz 35,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
table1 + id1 + table2 + id2 Primary key Asc/Asc/Asc/Asc asn_pk
id2 + table2 Performance Asc/Asc asn_idx_2