Similar assignments: Difference between revisions
Jump to navigation
Jump to search
(Created page with " This table was created for the task herehttp://wiki.expertiza.ncsu.edu/index.php/E1867_allow_reviewer_to_say_review_can_be_shown_to_class_as_an_example.") |
No edit summary |
||
| Line 1: | Line 1: | ||
The "similar_assignments" table is used to store mappings between assignments. | |||
This table was created for the task here | (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 == | |||
{| class="wikitable" | |||
!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, [http://wiki.expertiza.ncsu.edu/index.php/E1867_allow_reviewer_to_say_review_can_be_shown_to_class_as_an_example] 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). | |||
Revision as of 00:34, 21 November 2018
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).