Similar assignments

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