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
[edit]--------------- ------------------ ------ ----- --------- ---------------- | 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
[edit]---------------- ------------ ------------------- -------------- --------------- ----------- ------------- ---------- -------- ------ ------------ --------- --------------- | 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 | | | ---------------- ------------ ------------------- -------------- --------------- ----------- ------------- ---------- -------- ------ ------------ --------- ---------------
