...
| Status | ||||||
|---|---|---|---|---|---|---|
|
...
Purpose: Stores relationship pairs between questions and objectives.
...
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) |