watch table

Fields

Schema summary

 DESCRIBE watch;

+------------+---------------------+------+-----+-------------------+-----------------------------+
| Field      | Type                | Null | Key | Default           | Extra                       |
+------------+---------------------+------+-----+-------------------+-----------------------------+
| watch_id   | int(10) unsigned    | NO   | PRI | NULL              | auto_increment              |
| user_id    | int(10) unsigned    | NO   |     | 0                 |                             |
| page_id    | int(10) unsigned    | NO   |     | 0                 |                             |
| comment_id | int(10) unsigned    | NO   |     | 0                 |                             |
| pending    | tinyint(1) unsigned | NO   |     | 0                 |                             |
| watch_time | timestamp           | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+------------+---------------------+------+-----+-------------------+-----------------------------+

Indices

 SHOW INDEX IN watch;

+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table       | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wacko_watch |          0 | PRIMARY  |            1 | watch_id    | A         |          94 |     NULL | NULL   |      | BTREE      |         |               |
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+