Visiting Nurse sample application tables

This topic contains a description of each sample application table for the Visiting Nurse. See Overview of the Visiting Nurse sample application for an example of a Visiting Nurse application that uses DB2 Everyplace.

VNSCHEDULE
Contains the nurse's appointments. This table contains information such as patient ID and time of the appointment. The table schema is: 
CREATE TABLE VNSchedule (PatientID Char(9) NOT NULL,
                         Time_C Time PRIMARY KEY)

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. The table schema is: 
CREATE TABLE VNPerson (ID Char(9) PRIMARY KEY, 
                       Name Varchar(40), 
                       Address Varchar(50), 
                       City Varchar(30), 
                       HomePhone Varchar(20), 
                       WorkPhone Varchar(20), 
                       MobilePhone Varchar(20))

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. The table schema is: 
CREATE TABLE VNMedicalRecord (RecordID Integer PRIMARY KEY, 
                              Date_C Date, 
                              Time_C Time, 
                              PatientID Char(9) NOT NULL, 
                              BloodPressure Char(7), 
                              PulseRate Smallint, 
                              Temperature Decimal(4,1), 
                              Weight Decimal(5,2), 
                              Comment Varchar(100)) 

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. The table schema is: 
CREATE TABLE VNContact (PatientID Char(9) NOT NULL, 
                        ContactID Char(9) NOT NULL, 
                        Relationship Varchar(20), 
                        PRIMARY KEY (PatientID, ContactID))

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. The table schema is: 
CREATE TABLE VNSignature (RecordID Integer not null PRIMARY KEY, 
                          NurseName Varchar(40), 
                          Signature Blob(2000))

Related tasks

Related concepts