Log filter hits. An entry is inserted in this table each time manitou-mdx applies a set of actions given by the filter_expr and filter_action tables. A message may have several entries if several filters have been applied to it but the (mail_id,expr_id) combination should be unique.
The filter logs can be displayed in the user interface.
Structure of filter_log
expr_idinteger
The reference to the expression. It is intentional that there is no foreign key to the filter_expr table, to avoid having to delete entries in the logs when the associated filter is removed.
mail_idinteger
The reference to the message. It is intentional that there is no foreign key to the mail table, to avoid having to delete entries in the logs when the associated message is removed.
hit_datetimestamp with time zone
The date and time when the filter has been applied.
DEFAULT now()