Extension:BounceHandler/table bounce_records
La table bounce_records contient les enregistrements de la gestion des rebonds.
| Colonne | Description |
|---|---|
| br_id | index |
| br_user | L'ID du courriel en faute décodé à partir de l'entête de rebond. |
| br_timestamp | La référence horaire de rebond extraite des entêtes du courriel de rebond. |
| br_reason | Le sujet du message de rebond extrait du courriel de rebond. |
Schéma
+---------------+------------------+------+-----+---------+----------------+ | 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 | | +---------------+------------------+------+-----+---------+----------------+
Les index
+----------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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 | | | +----------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+