Table SIEM.public.states
Definitions of possible states of incidents

 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
stt_id int4 10
incidents
users
Unique identifier for the Status of different Contexts
context varchar 64  √  null Case or Context in abbreviated form
name varchar 64  √  null Detail of the Status of different contexts
terminal_flag varchar 1  √  null Indicates if state of incident is resolved.
date_created timestamptz 35,6 Date the entry was created
date_modified timestamptz 35,6 Date the entry was modified
modified_by int4 10  √  null User who last modified object
created_by int4 10  √  null User who created object

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

Indexes:
Column(s) Type Sort Anomalies
stt_id Primary key Asc  
context + name Must be unique Asc/Asc These unique columns are also nullable

Close relationships  within of separation: