Schema:changed verified pubs

Schema Summary

+-------------+----------+------+-----+---------+----------------+
| Field       | Type     | Null | Key | Default | Extra          |
+-------------+----------+------+-----+---------+----------------+
| change_id   | int(11)  | NO   | PRI | NULL    | auto_increment |
| pub_id      | int(11)  | YES  |     | NULL    |                |
| sub_id      | int(11)  | YES  |     | NULL    |                |
| verifier_id | int(11)  | YES  | MUL | NULL    |                |
| change_time | datetime | YES  |     | NULL    |                |
+-------------+----------+------+-----+---------+----------------+

Description

The changed_verified_pubs table is used to store data about primary-verified publications changed by other editors. At this time "changes" include publication edits as well as imports/exports of data into a publication.

• change_id - Unique key ID.

• pub_id - Publication ID; foreign key into pubs table.

• sub_id - Submission ID; foreign key into the submissions table.

• verifier_id - User ID of the user who primary-verifed this publication; foreign key into the mw_user table.

• change_time - MySQL date/time stamp documenting when the change was made.