Untitled

 avatar
unknown
plain_text
a year ago
1.1 kB
1
Indexable
+---------------+---------------------+------+-----+---------------------+-----------------------------+
| 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