Schema:user status

Schema Summary

+-----------------------+----------+------+-----+---------+----------------+
| Field                 | Type     | Null | Key | Default | Extra          |
+-----------------------+----------+------+-----+---------+----------------+
| user_status_id        | int(11)  | NO   | PRI | NULL    | auto_increment |
| user_id               | int(11)  | YES  | MUL | NULL    |                |
| last_changed_ver_pubs | datetime | YES  |     | NULL    |                |
| last_viewed_ver_pubs  | datetime | YES  |     | NULL    |                |
+-----------------------+----------+------+-----+---------+----------------+

Description

The user_status table is used to store information about each user's status. Each entry is associated with a registered user ID.

• user_status_id - Unique key ID.

• user_id - The user ID of the registered user.

• last_changed_ver_pubs - MySQL date/time stamp showing when this user's primary-verified publications were last modified by other users.

• last_viewed_ver_pubs - MySQL date/time stamp showing when this user last checked the report of changed primary-verified publications.