* viewer_id [INTEGER] This is the viewer(user) id of the user who is assigned to a person id. * person_id [INTEGER] This is the person id connected to the viewer id. */ $Access = new RowManager_AccessManager(); $Access->dropTable(); $Access->createTable(); /* * Region Table * * manages regions * * region_id [INTEGER] id of a region * reg_desc [STRING] description of a region */ $Region = new RowManager_RegionManager(); $Region->dropTable(); $Region->createTable(); /* * EmergencyInfo Table * * a record of emergency info for a person * * emerg_id [INTEGER] unique indentifier * person_id [INTEGER] Person id * emerg_passportNum [STRING] Passport number * emerg_passportOrigin [STRING] passport's country of origin * emerg_passportExpiry [DATE] passport date of expiry * emerg_contactName [STRING] emergency contact name * emerg_contactRship [STRING] emergency contact's relationship to the person * emerg_contactHome [STRING] emergency contact's home phone number * emerg_contactWork [STRING] emergency contact's work phone number
