* 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 * * this is a HRDB form field object * * fields_id [INTEGER] the unique id of the field * fieldtype_id [INTEGER] The field type associated with the field (i.e. "checkbox") * fields_desc [STRING] the description of the form field * staffscheduletype_id [INTEGER] id of the form that this field belongs to * fields_priority [INTEGER] the display priority of this form field * fields_reqd [BOOL] whether or not this field is a required field (for the user to fill in) * fields_invalid [STRING] an value that is invalid for this field * fields_hidden [BOOL] whether this field is hidden to the general user * datatypes_id [INTEGER] The id of the type of data this field expects, i.e. "numeric".