Purpose: When not obtaining learning objectives from a VLE through an API Rogo can store objectives internally - this table is for this purpose.
Joins: modules and sessions table.
| Field | Type | Purpose | |
|---|---|---|---|
| obj_id | int(11) | Primary Key | |
| objective | text | Text of the objective itself | |
| idMod | int(11) unsigned | Primary Key - ID of the module the objectives are stored against | |
| identifier | bigint(20) unsigned | Joins with sessions table | |
| calendar_year | enum('2008/09','2009/10','2010/11','2011/12','2012/13','2013/14', '2014/15','2015/16','2016/17','2017/18','2018/19','2019/20') | Primary Key - Academic year objectives pertain to | |
| sequence | int(11) | What order the objectives are displayed on screen |
See also: Curriculum Map
The Information below is for an in development branch of Rogo
Purpose: When not obtaining learning objectives from a VLE through an API Rogo can store objectives internally - this table is for this purpose.
Version: 6.1
Joins: academic_year, modules and sessions table.
| Field | Type | Purpose | Key |
|---|---|---|---|
| obj_id | int(11) | PRIMARY KEY | |
| objective | text | Text of the objective itself | |
| idMod | int(11) unsigned | ID of the module the objectives are stored against | PRIMARY KEY |
| identifier | bigint(20) unsigned | Joins with sessions table | |
| calendar_year | int(4) | Academic year the metadata applies to. | PRIMARY KEY, FOREIGN KEY academic_year.calendar_year |
| sequence | int(11) | What order the objectives are displayed on screen |