...
| Status | ||||||
|---|---|---|---|---|---|---|
|
...
Purpose: Used to store academic sessions used through the system.
...
| 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 |