Similar assignments: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
The "similar_assignments" table is used to store mappings between assignments. | The "similar_assignments" table is used to store mappings between assignments. | ||
Given an assignment id and association type, it answers two questions: | Given an assignment id and association type, it answers two questions: | ||
| Line 42: | Line 38: | ||
|Date time value when the record was updated. | |Date time value when the record was updated. | ||
|} | |} | ||
== Use of the table == | == Use of the table == | ||
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. |
| 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).