Purpose: Holds data about a session (or activity) which is a container into which objectives can be structured.
Joins: objectives and modules tables.
| Field | Type | Purpose |
|---|---|---|
| sess_id | int(11) | auto increment. |
| identifier | bigint(20) unsigned | Primary Key – Number that joins with objectives table |
| idMod | char(25) unsigned | Primary Key – ID of the module the session pertains to |
| title | text | The title of the session |
| source_url | text | Optional URL to point to. The intention would be to point to a lecture page in a VLE or portal |
| calendar_year | Primary Key – 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') | Academic year of the session |
| occurrence | datetime | Datetime when the session occurrs |
| Warning |
|---|
The Information below is for an in development branch of RogoROGO 6.1.0+ |
Purpose: Holds data about a session (or activity) which is a container into which objectives can be structured.Version: 6.1
Joins: academic_year, objectives and modules tables.
Field | Type | Purpose | Key |
|---|---|---|---|
| sess_id | int(11) | auto increment. | |
| identifier | bigint(20) unsigned | Number that joins with objectives table | PRIMARY KEY |
| idMod | char(25) unsigned | ID of the module the session pertains to | PRIMARY KEY |
| title | text | The title of the session | |
| source_url | text | Optional URL to point to. The intention would be to point to a lecture page in a VLE or portal | |
| calendar_year | int(4) | Academic year the metadata applies to. | PRIMARY KEY, FOREIGN KEY academic_year.calendar_year |
| occurrence | datetime | Datetime when the session occurrs |