* emerg_medicalNotes [STRING] medical notes about this person */ $EmergencyInfo = new RowManager_EmergencyInfoManager(); $EmergencyInfo->dropTable(); $EmergencyInfo->createTable(); /* * CampusAssignmentStatus Table * * The status of a person assigned to some campus. * * assignmentstatus_id [INTEGER] unique identifier for a particular campus assignment status * assignmentstatus_desc [STRING] Description of a particular campus assignment status */ $CampusAssignmentStatus = new RowManager_CampusAssignmentStatusManager(); $CampusAssignmentStatus->dropTable(); $CampusAssignmentStatus->createTable(); /* * EditCampusAssignment Table * * Page used to edit campus assignments for people. Assigns campus and some sort of campus status (i.e. student, staff, alumni, etc) to a person. * * assignment_id [INTEGER] Unique id of some campus assignment for some student * person_id [INTEGER] Unique id of the person being assigned a campus * campus_id [INTEGER] Unique ID of the campus being assigned to a person * assignmentstatus_id [INTEGER] ID referring to a particular status w.r.t. a campus (i.e. student, staff, etc) */ $EditCampusAssignment = new RowManager_EditCampusAssignmentManager(); $EditCampusAssignment->dropTable(); $EditCampusAssignment->createTable(); /* * ViewerToPersonAssignment Table