Similar assignments: Difference between revisions

From Expertiza_Wiki
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 other assignments that it is similar to.
- find all its similar assignments.
# 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.
|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.
|-
!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
Line 41: Line 37:
== Use of the table ==
== 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'.
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:

  1. find other assignments that it is similar to.
  2. 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).