Schema:primary verifications
Jump to navigation
Jump to 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