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. |
Schema
+---------------+------------------+------+-----+---------+----------------+ | 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 | | +---------------+------------------+------+-----+---------+----------------+
Indexes
+----------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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 | | | +----------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
