Table SIEM.public.ixlog_part
Details of the event partitions located in the file-based event store

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
part_id int8 19
incidents_events.part_id Implied Constraint R
incidents_events_rpt_v.part_id Implied Constraint R
Identifier of Index Log of partitions
name varchar 255 Partition name
part_date date 13 Partition date
ret_pol_id uuid 2147483647  √  null
md_config.config_id ret_pol_id_fk R
Retention policy identifier
byte_count int8 19  √  null Size of the event
event_count int8 19  √  null Event count for the partition
hash varchar 255  √  null Hash value
state int4 10 0 Status of log
index_version int4 10 0 Version of log
event_assoc_action int4 10  √  null Event associated action
event_assoc_data_in_db int4 10  √  null Existence of event associated data in database
event_assoc_data_exported bool 1  √  null Indicator of events associated data export
event_assoc_action_start_time timestamptz 35,6  √  null Starting time of events associated action
event_assoc_data_export_hash varchar 255  √  null Hash for events associated data exported
incidents_events_exported int8 19  √  null Incident events exported
correlated_events_exported int8 19  √  null Correlated events exported
incidents_events_imported int8 19  √  null Incident events imported
correlated_events_imported int8 19  √  null Correlated events imported
date_created timestamptz 35,6  √  null Date the entry was created
date_modified timestamptz 35,6  √  null 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
part_id Primary key Asc part_pk
part_date Performance Desc ixlog_part_day_idx
name Performance Asc ixlog_part_name_idx
ret_pol_id Performance Asc ixlog_part_ret_pol_id_idx
state Performance Asc ixlog_part_state_idx

Close relationships: