Forum .LRN Q&A: Re: Tables related with exam answers and grades

Collapse
Posted by Emmanuelle Raffenne on
Hi Irma,

The table I pointed stores the individual answer data (user identifier, evaluation identifier, etc.) except the file that has been uploaded by the student.

Note there is a foreign key on evaluation_answers.answer_id to cr_revisions.revision_id (content repository). "evaluation_answers" is a subtype of the "cr_revision" acs object type. All the specific data related to evaluation that can't be handled by the content repository is stored in the evaluation_answers table.

The file uploaded by student is stored in the content repository. Depending on the storage type, the physical file will be stored in the database (lob column of the cr_revisions table) or in the file system. The storage type is set by the StoreFilesInDatabaseP parameter of the evaluation package instance.

You can have a look at the script that handles the uploading of answers to understand what happens: packages/evaluation/www/answer-add-edit.tcl. It calls the evaluation::new_answer Tcl procedure. In turn, evaluation::new_answer calls content::revision::new to create a new revision for the answer.

I hope that will clear things up a little.