Schema:verification

Schema Summary

+-----------------+----------+------+-----+---------+----------------+
| Field           | Type     | Null | Key | Default | Extra          |
+-----------------+----------+------+-----+---------+----------------+
| verification_id | int(11)  | NO   | PRI | NULL    | auto_increment |
| pub_id          | int(11)  | YES  | MUL | NULL    |                |
| reference_id    | int(11)  | YES  | MUL | NULL    |                |
| user_id         | int(11)  | YES  | MUL | NULL    |                |
| ver_time        | datetime | YES  |     | NULL    |                |
| ver_status      | int(11)  | YES  |     | NULL    |                |
+-----------------+----------+------+-----+---------+----------------+

Description

The secondary verification table is used to verify a publication. There can be a verification record for each reference in the reference table. The verification record sets the verification state for a particular publication, against a particular reference, recording the user and time the verification was made.

• verification_id - This column is the unique record id for the verification table.

• pub_id - This column is a foreign key which points to a publication record.

• reference_id - This column is a foreign key which points to a reference record.

• user_id - This column is a foreign key which points to a user record.

• ver_time - Timestamp when the verification data was submitted.

• ver_status - The verification status for this publication for the specified reference. Can be one of:
  • 0 - Not verified.
  • 1 - Verified.
  • 2 - The reference has no data on this publication.