The Data Explorer's SuggestedEditVotes
table has a VoteTypeId
column that can be either 2 or 3 to indicate Approve or Reject, respectively. "Improve Edit" and "Reject and Edit" votes, though, don't appear in that table at all. They do add to ReviewTaskResults
with an appropriate ReviewTaskResultTypeId
(5 and 19 are options), but that table has no UserId
column.
It seems inconsistent to record some Suggested Edits review results in both tables but some in only one. Conveniently, 2 and 3 have the same meaning as a VoteTypeId
and a ReviewTaskResultTypeId
, so the missing entries could be added to SuggestedEditVotes
. Alternatively, add a new ReviewTaskResultTypeId
column to avoid changing the possible value set of an existing one.
Adding a UserId
column to ReviewTaskResults
would also do the job, per this other request.