Table user_course has received a new column called status. The new status column is of TINYINT type.
The new status column is intended to be used to indicate if a student is waiting for teacher to accept student to course or if teacher has accepted. If status has value 1 the user is accepted to the course. If value is 0 then teacher has not yet accepted or rejected the user.
I currently do not plan any specific status value for rejection. Instead, if a teacher rejects the student then the student's row in table user_course is simply deleted and student can reapply again.
stmi11
commented
8 years ago
Following changes are implemented:
user_coursehas received a new column calledstatus. The newstatuscolumn is ofTINYINTtype.statuscolumn is intended to be used to indicate if a student is waiting for teacher to accept student to course or if teacher has accepted. Ifstatushas value1the user is accepted to the course. If value is0then teacher has not yet accepted or rejected the user.statusvalue for rejection. Instead, if a teacher rejects the student then the student's row in tableuser_courseis simply deleted and student can reapply again.