announcements

Purpose: Used to post notices/announcements on the staff and student homepages.

FieldTypePurpose
idint(11)Primary Key – auto increment.
titlevarchar(255)Title heading of the announcement.
staff_msgtextMessage to display on staff homepage /staff/
student_msgtextMessage to display on student homepage /student/
iconvarchar(255)Icon symbol to use.
startdatedatetimeDate when the announcement starts to be displayed.
enddatedatetimeDate when the announcement stops being displayed.
deleteddatetimeDate the announcement was deleted. NULL dates are still live.