Similar assignments: Difference between revisions

From Expertiza_Wiki
Jump to navigation Jump to search
No edit summary
Line 17: Line 17:
|int(11)  
|int(11)  
|unique id of assignment, and is a foreign key to assignments table.
|unique id of assignment, and is a foreign key to assignments table.
|-
!assignment_id 
|int(11)
|ID of assignment.
|-  
|-  
!is_similar_for
!is_similar_for
|int(11)   
|int(11)   
|assignment that is similar to assignment_id
|assignment that is similar to assignment_id, and is a foreign key to assignments table.
|-  
|-  
!association_intent
!association_intent

Revision as of 00:37, 21 November 2018

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

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.
is_similar_for int(11) assignment that is similar to assignment_id, and is a foreign key to assignments table.
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).