Extension:BounceHandler/bounce records table

The bounce_records table contains the bounce handling records

Column Description
br_id index
br_user The failing email id decoded from bounce headers.
br_timestamp The bounce time-stamp extracted from the bounce email headers.
br_reason The bounce message subject extracted from the bounce email.

SchemaEdit

+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| br_id         | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| br_user_email | varbinary(255)   | NO   | MUL | NULL    |                |
| br_timestamp  | binary(14)       | NO   | MUL | NULL    |                |
| br_reason     | varbinary(255)   | NO   |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+

IndexesEdit

+----------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table          | Non_unique | Key_name          | Seq_in_index | Column_name   | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| bounce_records |          0 | PRIMARY           |            1 | br_id         | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| bounce_records |          1 | br_mail_timestamp |            1 | br_user_email | A         |           0 |       50 | NULL   |      | BTREE      |         |               |
| bounce_records |          1 | br_mail_timestamp |            2 | br_timestamp  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| bounce_records |          1 | br_timestamp      |            1 | br_timestamp  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+----------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+