Difference between revisions of "Schema:verification"
Jump to navigation
Jump to search
(Breaking up larger article) |
(→Description: +secondary) |
||
Line 14: | Line 14: | ||
==Description== | ==Description== | ||
− | The 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. | + | 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. | * '''verification_id''' - This column is the unique record id for the verification table. |
Latest revision as of 13:03, 16 April 2017
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.