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
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.
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.
timestamp with time zone
The date and time when the filter has been applied.