Schema:primary verifications

Schema Summary

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

Description

The primary verification table is used to verify a publication. It records the user, the time when the publication was verified and whether the verification was permanent or transient.

• 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.

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

• ver_time - Timestamp when the verification record was created.

• ver_transient - The verification status for this verification. Can be one of:
  • NULL - permanent verification
  • 1 - transient verification