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 |
+-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| dev_watch |          0 | PRIMARY  |            1 | watch_id    | A         |          39 |     NULL | NULL   |      | BTREE      |         |               |
+-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+