[Space left intentionally blank] Name Input Output Description Creates a new OrganizationID row in (string), Age Integer number of rows USER_INFO; (integer), Sex affected. 0 means the called from create_user (char) create failed. registerUser RecordID (integer), OrganizationID (string), Age Integer number of rows Updates a row (integer), Sex affected. 0 means the in the User_Info update_user (char) update failed. table. Gets all User_Info select_user_all none record set records Gets the record RecordID with the ID select_user_recordID (integer) record set (one row) provided. Integer number of rows Removes a row RecordID affected. 0 means that no from the delete_user (integer) deletion occured. User_Info table. RecordID (integer), UserID Integer number of rows Creates a new (integer), IsActive affected. 0 means the create row in the create_fob (boolean) failed. Fob_Info table. RecordID (integer), UserID Integer number of rows Updates a row (integer), IsActive affected. 0 means the in the Fob_Info update_fob (boolean) update failed. table. Gets all rows from the select_fob_all none record set Fob_Info table. Gets the record RecordID with the ID select_fob_recordid (integer) record set (one row) provided. Gets all rows select_fob_all_active none record set from the
[Space left intentionally blank] Name Input Output Description create_user OrganizationID (string), Age (integer), Sex (char) Integer number of rows affected. 0 means the create failed. Creates a new row in USER_INFO; called from registerUser update_user RecordID (integer), OrganizationID (string), Age (integer), Sex (char) Integer number of rows affected. 0 means the update failed. Updates a row in the User_Info table. select_user_all none record set Gets all User_Info records select_user_recordID RecordID (integer) record set (one row) Gets the record with the ID provided. delete_user RecordID (integer) Integer number of rows affected. 0 means that no deletion occured. Removes a row from the User_Info table. create_fob RecordID (integer), UserID (integer), IsActive (boolean) Integer number of rows affected. 0 means the create failed. Creates a new row in the Fob_Info table. update_fob RecordID (integer), UserID (integer), IsActive Integer number of rows affected. 0 means the update failed. Updates a row in the Fob_Info table. (boolean) select_fob_all none record set Gets all rows from the Fob_Info table. select_fob_recordid RecordID (integer) record set (one row) Gets the record with the ID provided. select_fob_all_active none record set Gets all rows from the