Reviews

From Expertiza_Wiki
Revision as of 22:06, 25 April 2018 by Psinha (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Reviews provide a means or communicating information from one user to another about the submission content.

Deprecated

Reviews variable documentation

Field Name Type Description
id int(11) The unique record id
review_mapping_id int(11) The ID of the review mapping used to define the relationship between and author/team and a reviewer
review_num_for_author int(11) (Unused at present?) This is supposed to be the review number, as seen by the author. [Should be changed to review_num_for_creator]
review_num_for_reviewer int(11) (Unused at present?) This is supposed to be the review number, as seen by the reviewer. Normally for non-team assignments, it will be the same as the review_num_for_author. For team assignments, it often differs from review_num_for_author, because the creator receives more reviews than each individual reviewer creates.
ignore tinyint(4) Designate that a given review is not included in the score. May be unused
additional_comment text An additional comment provided by the reviewer to support his/or her review content
updated_at datetime The timestamp indicating when this review was last modified
created_at datetime The timestamp indicating when this review was created

E/R diagram for Parents Tables

Tables referred by the Reviews Table as Foreign Key Relationship.



E/R diagram for Child Tables

Tables referred by the Reviews Table as Foreign Key Relationship.

Back to the database documentation