Schema:primary verifications

From ISFDB

Jump to: navigation, search

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
Personal tools