Schema:verification

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