* person_id [INTEGER] Unique identifier for some person record */ $ViewerToPersonAssignment = new RowManager_ViewerToPersonAssignmentManager(); $ViewerToPersonAssignment->dropTable(); $ViewerToPersonAssignment->createTable(); /* * YearInSchool Table * * Manages the cim_hrdb_year_in_school table * * year_id [INTEGER] unique id * year_desc [STRING] text description of the year in school */ $YearInSchool = new RowManager_YearInSchoolManager(); $YearInSchool->dropTable(); $YearInSchool->createTable(); /* * PersonYear Table * * Manages the cim_hrdb_personyear table * * year_id [INTEGER] id referencing year status * grad_date [DATE] expected graduation date */ $PersonYear = new RowManager_PersonYearManager(); $PersonYear->dropTable(); $PersonYear->createTable(); /* * ActivityType Table * * a type of schedule activity (i.e. vacation, etc)