Purpose: Stores relationship pairs between questions and objectives.
Joins: papers, modules and questions tables.
| Field | Type | Purpose |
|---|---|---|
| rel_id | int(11) | Primary Key – auto increment. |
| 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 | enum('2006/07', '2007/08', '2008/09', '2009/10', '2010/11', '2011/12', '2012/13', '2013/14', '2014/15', '2015/16', '2016/17', '2017/18', '2018/19', '2019/20') | The academic year the objectives are linked to. |
| vle_api | varchar(255) | which vle api is this relationship for |
| map_level | smallint(2) |
| Warning |
|---|
The Information below is for an in development branch of RogoROGO 6.1.0+ |
Purpose: Stores relationship pairs between questions and objectives.Version: 6.1
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) |