* week_id [INTEGER] unique id of the week * week_endDate [DATE] Ending date of the week */ $Week = new RowManager_WeekManager(); $Week->dropTable(); $Week->createTable(); /* * Semester Table * * Manages information related to semesters * * semester_id [INTEGER] unique id of a semester * semester_desc [STRING] Textual description of the semester */ $Semester = new RowManager_SemesterManager(); $Semester->dropTable(); $Semester->createTable(); /* * SemesterReport Table * * Manages stats information for a campus from a given semester * * semesterreport_id [INTEGER] Unique id * semesterreport_avgPrayer [INTEGER] Average attendence at prayer meetings over the semester * semesterreport_avgWklyMtg [INTEGER] The average attendence at the weekly meetings over the semester. * semesterreport_numStaffChall [INTEGER] Number of people challenged to staff * semesterreport_numInternChall [INTEGER] number challenged to an internship * semesterreport_numFrosh [INTEGER] number of frosh involved * semesterreport_numStaffDG [INTEGER] number of staff led DGs * semesterreport_numInStaffDG [INTEGER] number of students in staff led DGs * semesterreport_numStudentDG [INTEGER] number of student led DGs