The Information below is for ROGO 6.1.0+
Purpose: Stores relationship pairs between questions and objectives.
Joins: academic_year, papers, modules and questions tables.
Field | Type | Purpose | Key |
|---|---|---|---|
| rel_id | int(11) | auto increment. | PRIMARY KEY |
| idMod | int(11) unsigned | Module ID of the paper and objectives. | |
| paper_id | mediumint(8) unsigned | Paper ID | |
| question_id | int(11) | ID of the question being mapped to the objective. | |
| obj_id | int(11) | ID of the objective being mapped to the question. | |
| calendar_year | int(4) | Academic year the metadata applies to. | FOREIGN KEY academic_year.calendar_year |
| vle_api | varchar(255) | which vle api is this relationship for | |
| map_level | smallint(2) |