Table SIEM.public.incidents
Details of incidents

 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
inc_id int4 10
incidents_assets.inc_id Implied Constraint R
incidents_assets_rpt_v.inc_id Implied Constraint R
incidents_events.inc_id inc_inc_evt_fk R
incidents_events_rpt_v.inc_id Implied Constraint R
incidents_rpt_v.inc_id Implied Constraint R
incidents_vuln.inc_id Implied Constraint R
incidents_vuln_rpt_v.inc_id Implied Constraint R
unassigned_incidents_rpt_v.inc_id Implied Constraint R
Incident identifier - sequence number
name varchar 255  √  null Incident name
severity int4 10  √  null Incident severity
stt_id int4 10
states.stt_id int_ste_fk R
Incident State ID
severity_rating varchar 32  √  null Average of all the event severities that comprise an incident.
vulnerability_rating varchar 32  √  null Reserved for future use by Novell. Use of this field for any other purpose might result in data being overwritten by future functionality.
criticality_rating varchar 32  √  null Reserved for future use by Novell. Use of this field for any other purpose might result in data being overwritten by future functionality.
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
inc_desc varchar 4000  √  null Incident description
inc_cat varchar 255  √  null Incident category
inc_priority int4 10  √  null Incident priority
inc_res varchar 4000  √  null Incident resolution

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

Indexes:
Column(s) Type Sort Constraint Name
inc_id Primary key Asc inc_pk
date_created + name + stt_id Performance Asc/Asc/Asc inc_name_stt_idx
date_created + severity Performance Asc/Asc inc_sev_idx
date_created + stt_id Performance Asc/Asc inc_stt_id_idx

Close relationships  within of separation: