...
| Status | ||||||
|---|---|---|---|---|---|---|
|
...
Purpose: Holds data about a session (or activity) which is a container into which objectives can be structured.
...
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 |