Table SIEM.public.filters
Filters used for various contexts

Generated by
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
filter_id uuid 2147483647
global_filters.filter_id Implied Constraint R
This is the UUID of the filter.
filter_name varchar 255 This is the name of the filter
filter_desc varchar 1024  √  null Description of the filter.
user_owner_id int4 10
users.usr_id filters_user_owner_id_fk C
User ID of the owner of this filter
value text 2147483647 The actual lucene query forming the filter.
share_type varchar 50 Denotes how the filter is shared. It can have one of these four values - "NONE","EVERYONE","SAME_ROLE","SELECTED_ROLES"
is_freeform bool 1  √  null Denotes whether the query was built using builder or freeform.
builder_data text 2147483647  √  null If query was built using builder, then this column stores the builder data associated with it used to display it back in UI later.
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

Column(s) Type Sort Constraint Name
filter_id Primary key Asc filters_pk
filter_name + user_owner_id Must be unique Asc/Asc user_filter_name_unique

Close relationships  within of separation: