Similar assignments: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| (4 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
Given an assignment id and association type, it answers two questions: | 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 == | == Table Structure == | ||
| Line 12: | Line 12: | ||
!id | !id | ||
|int(11) | |int(11) | ||
| | |unique ID for each similar_assignments record. | ||
|- | |- | ||
!assignment_id | !assignment_id | ||
|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. | ||
|- | |- | ||
!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 | ||
| Line 41: | Line 37: | ||
== Use of the table == | == Use of the table == | ||
This table | This table has been created for the task [http://wiki.expertiza.ncsu.edu/index.php/E1867_allow_reviewer_to_say_review_can_be_shown_to_class_as_an_example here] 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). | The table can be reused for any future task that requires to create associations between assignments for any other intent (like rating score). | ||
Latest revision as of 00:43, 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 has been created for the task here 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).