Manitou-Mail Home

8.  Table: filter_expr

Contains the conditions names and expressions of the filtering system.

Structure of filter_expr

expr_id

integer PRIMARY KEY

Unique ID for the expression.

name

character varying(100)

Name of the condition

user_lastmod

integer

Id of the last user who modified the condition.

last_update

timestamp with time zone

Date of the last update of the row.

DEFAULT now()

expression

text

Text of the expression. This is what is evaluated by the filtering system to compute whether the condition is true or false.

direction

character(1)

Indicates if the filter should be used for incoming messages (direction='I'), outgoing messages (direction='O') or both incoming and outgoing (direction='B').

DEFAULT 'I'::bpchar

Tables referencing filter_expr via Foreign Key Constraints