Purpose: When not obtaining learning objectives from a VLE through an API Rogo can store objectives internally - this table is for this purpose.
Joins: academic_year, modules and sessions table.
Primary Key | PRIMARY KEY |
objective | text | Text of the objective itself |
| Primary Key - ID of the module the objectives are stored against |
PRIMARY KEY |
identifier | bigint(20) unsigned | Joins with sessions table |
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 | 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 |
| ...