Move turnitin_id attributes on content_resource.binary_entity to contentreview_item.externalId
Description
Background:
When a student submits an assignment, contentreview_items are created for the attachments.
The Content Review Queue job posts these attachments to Turnitin, turnitin responds whether the post was successful.
An asynchronous callback from Turnitin then gives us the "externalId" (the ID of the submitted file on TII's end).
The reports job then uses the "externalId" to retrieve Turnitin's originality report
Currently step 3 sets the externalId in the content_resource table's binary_entity column. This table represents files on the file system. There already exists an externalId column in contentreview_item specifically for this purpose which we are now just leaving null.
We should move the externalId to contentreview_item as it is a content-review specific datum, and this will make externalIds more searchable.
Background:
When a student submits an assignment, contentreview_items are created for the attachments.
The Content Review Queue job posts these attachments to Turnitin, turnitin responds whether the post was successful.
An asynchronous callback from Turnitin then gives us the "externalId" (the ID of the submitted file on TII's end).
The reports job then uses the "externalId" to retrieve Turnitin's originality report
Currently step 3 sets the externalId in the content_resource table's binary_entity column. This table represents files on the file system. There already exists an externalId column in contentreview_item specifically for this purpose which we are now just leaving null.
We should move the externalId to contentreview_item as it is a content-review specific datum, and this will make externalIds more searchable.