...
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
Warning |
---|
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 |