+---------------+---------------------+------+-----+---------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------------------+-----------------------------+
| id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| user_id | bigint(20) unsigned | NO | MUL | NULL | |
| email_type_id | bigint(20) unsigned | NO | MUL | NULL | |
| opt_out | tinyint(1) | YES | MUL | 1 | |
| date_updated | timestamp | NO | | 2000-01-01 00:00:00 | on update CURRENT_TIMESTAMP |
| date_created | datetime | NO | | CURRENT_TIMESTAMP | |
+---------------+---------------------+------+-----+---------------------+-----------------------------+
w