This space is archived
For current information please use the current ExamSys documentation
relationships
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) |