Overview of the Visiting Nurse sample application

The Visiting Nurse application provides an example of an application that uses DB2 Everyplace. For Palm OS, the application was developed in C using Metrowerks CodeWarrior for Palm Computing Platform. For Windows CE, the application was developed in C using Microsoft eMbedded Visual C++ 3. For Symbian OS v6, the application was developed in C++ using Microsoft Visual C++ Version 6 and Symbian C++ Software Developers Kit.

This sample application is designed for nurses who visit patients at their homes. Without this DB2 Everyplace application, the nurses would have to take notes on paper, then later transcribe their notes into a database on a workstation in their offices. After performing an initial synchronization with the server, the visiting nurses can:

• Access a patient's general information, such as name, address, phone number, and medical condition.
• Collect a patient's medical status, such as blood pressure, pulse rate, temperature, and weight.
• Get an automatic time and date stamp on the new medical record.
• Access a list of people to contact in case of an emergency.

At the end of the day, the visiting nurse can synchronize the data on the mobile device with a central database to:

• Update the central database with the patient status
• Obtain a list of patients to visit the next day

The database for this example includes five tables.

VNSCHEDULE

Contains the nurse's appointments. This table contains information such as patient ID and time of the appointment.

VNPERSON

Contains data about the patients. This table contains information such as name, Social Security Number, address, and phone numbers. The Social Security Number is used as the primary key.

VNMEDICALRECORD

Contains the patients' medical records. This table contains information such as blood pressure, pulse rate, and temperature. The medical record ID is used as the primary key.

VNCONTACT

Contains the list of emergency contacts for each patient. This table contains information such as the patient Social Security Number, emergency contact name, and relationship to the patient.

VNSIGNATURE

Contains binary signature data. This table is empty when created by the NurseInit application. This table is used with the Visiting Nurse Plus application and DB2 Everyplace Mobile Application Builder.

Related tasks

• Running the Visiting Nurse application

Related reference

• Visiting Nurse sample application tables