Similar assignments

From Expertiza_Wiki
Revision as of 00:34, 21 November 2018 by Aagniho (talk | contribs)
Jump to navigation Jump to search

The "similar_assignments" table is used to store mappings between assignments.

(x,y) (z,y) (x,l)

Given an assignment id and association type, it answers two questions: - find other assignments that it is similar to. - find all its similar assignments.

Table Structure

Field Name Type Description
id int(11) Unique ID for each similar_assignments record.
assignment_id int(11) unique id of assignment, and is a foreign key to assignments table.
assignment_id int(11) ID of assignment.
is_similar_for int(11) assignment that is similar to assignment_id
association_intent string why this particular association between the two assignments was created
created_at datetime Date time value when the record was created.
updated_at datetime Date time value when the record was updated.


Use of the table

This table was created for the task here, [1] which uses rows of the table having 'association_intent' as 'review'.

The table can be reused for any future task that requires to create associations between assignments for any other intent (like rating score).