Schema:verification
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 | | | 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.