Database Schema

An example database looks like this:

+-------------+---------------+----------------+----------------------+--------------+--------+
| sender_name | sender_domain | src            | mta_fqdn             | dest_address | policy |
+-------------+---------------+----------------+----------------------+--------------+--------+
| *           | foo.com       | 66.162.173.130 | *                    | foo@foo.com  |      1 | 
| *           | bar.com       | 66.162.173.130 | *                    | *@foo.com    |      1 | 
| *           | baz.com       | *              | *                    | *@foo.com    |      2 | 
| *           | *             | *              | *.bunchaspammers.com | *@foo.com    |      2 | 
+-------------+---------------+----------------+----------------------+--------------+--------+

The database consists of five fields per entry:

• sender_name- the 'user' part of the sender's email address ie: user@domain.tld
• sender_domain- the 'domain' part of the sender's email address ie: user@domain.tld
• src- the source IP address of the connecting client
• mta_fqdn- The fully-qualified domain name of the connecting client
• dest_address- the destination email address
• policy- the rule determining whether to accept(1) or deny(2) the email