Schema:user status
Jump to navigation
Jump to search
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.