Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Status
colourRed
titleRogo 6.1.0


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.

FieldTypePurpose
  
Key
obj_idint(11)
Primary Key

PRIMARY KEY
objectivetextText of the objective itself
 

idModint(11) unsigned
Primary Key -
ID of the module the objectives are stored against
 
PRIMARY KEY
identifierbigint(20) unsignedJoins 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
int(4)Academic year the metadata applies to.PRIMARY KEY, FOREIGN KEY academic_year.calendar_year
sequenceint(11)What order the objectives are displayed on screen
 

...