Extension:退信处理器/退信记录表
bounce_records資料表包含退信處理記錄
| column | 描述 |
|---|---|
| br_id | 索引 |
| br_user | 從退信標頭中解碼出的失敗電子郵件地址。 |
| br_timestamp | 從退信電子郵件的標頭中擷取的退信時間戳記。 |
| br_reason | 從退信電子郵件中擷取的退信訊息主旨。 |
架構
+---------------+------------------+------+-----+---------+----------------+ | 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 | | | +----------------+------------+-------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
