The information below is for an in development branch of Rogo
Purpose: Used to store academic sessions used through the system.
Version: 6.1
Joins: users_metadata, sms_imports, sessions, relationships, properties, objectives, modules_student
| Field | Type | Purpose | Key |
|---|---|---|---|
| calendar_year | int(4) | Calendar start year of session i.e. 2014 | PRIMARY KEY |
| academic_year | varchar(30) | Free text description of session i.e. 2014/15 | |
| cal_status | tinyint(1) | Flag for visibility in calendar | |
| stat_status | tinyint(1) | Flag for visibility in statistics | |
| deleted | datetime | Time stamp of when the session was deleted | |
| deletedby | int(10) | users.id for user who deleted the session |