Purpose: Used to post notices/announcements on the staff and student homepages.
Version: 4.2
| Field | Type | Purpose |
|---|---|---|
| id | int(11) | Primary Key – auto increment. |
| title | varchar(255) | Title heading of the announcement. |
| staff_msg | text | Message to display on staff homepage /staff/ |
| student_msg | text | Message to display on student homepage /student/ |
| icon | varchar(255) | Icon symbol to use. |
| startdate | datetime | Date when the announcement starts to be displayed. |
| enddate | datetime | Date when the announcement stops being displayed. |
| deleted | datetime | Date the announcement was deleted. NULL dates are still live. |
...