The LogDB.SpamRules table contains a record of the spamfilter rules which matched for messages logged by VPOP3. A message may have zero or more spamrules entries

• spamruleid - this is a bigint sequential value which identifies the spam rule entry uniquely in the database
• msgid - this is a bigint value linking this message to a message
• name - the spam rule name
• testpattern - the spam rule test pattern which matched (if any)
• testmatch - the message content which matched the pattern (if any)
• score - the spam filter score assigned by the spam rule match