$StaffScheduleType->createTable(); /* * StaffSchedule Table * * A particular staff person's schedule * * staffschedule_id [INTEGER] Unique id of the person's schedule * person_id [INTEGER] The id of the person associated with this schedule * staffscheduletype_id [INTEGER] the id of the form associated with this personal schedule * staffschedule_approved [BOOL] boolean indicating director's approval * staffschedule_approvedby [INTEGER] the person_id of the director approving the schedule * staffschedule_lastmodifiedbydirector [DATE] the timestamp of the last change *made by a director* * staffschedule_approvalnotes [STRING] notes made by the director regarding approval */ $StaffSchedule = new RowManager_StaffScheduleManager(); $StaffSchedule->dropTable(); $StaffSchedule->createTable(); /* * ActivitySchedule Table * * object linking an activity to some schedule; allows an activity to be associated with more than one schedule/form * * activityschedule_id [INTEGER] unique id of the object * staffactivity_id [INTEGER] the id of the staff activity * staffschedule_id [INTEGER] id of the schedule/form to associated with the activity */ $ActivitySchedule = new RowManager_ActivityScheduleManager(); $ActivitySchedule->dropTable(); $ActivitySchedule->createTable(); /* * FormField Table
