...
| Status | ||||||
|---|---|---|---|---|---|---|
|
Purpose: When not obtaining learning objectives from a VLE through an API Rogo can store objectives internally - this table is for this purpose.
...
| 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 |