Data Stores

The app uses the following data stores:

SharePoint Lists

The e-prescriptions app leverages SharePoint lists to store detailed information about the hospital, doctor, patient, and prescription. These three SharePoint lists used in the app:

• Patients List (Additional document library for prescriptions)
• Doctors List
• Hospital List
• Archival Site (with a mirror of patients list that also stores the prescriptions)

Let’s get started on creating the SharePoint lists:

1. Patients List – the patients list stores the details of the consulted patient

Name of Column	Type	Comment
Title	Single line of text	The patient name
Email	Single line of text	The patient’s Email ID
Phone	Single line of text	The patient’s phone number
DateOfConsultation	Date Type	The doctor’s date of consultation
ConsultationTime	Single line of text	The time of consultation
Age	Number	The age of the patient
Gender	Single line of text	The gender of the patient
MedicineDetails	Multiple lines of text	The medical details given by the doctor
DoctorRegistrationNumber	Single line of text	The doctor registration number
DoctorName	Single line of text	Name of the doctor
Qualification	Single line of text	Qualification of doctor
EPrescriptionNumber	Single line of text	E-Prescription number

2. Doctors List – the doctors list stores the details of the doctors in the hospital that are registered in E-Prescription app

Name of Column	Type	Comment
Title	Single line of text	The name of the doctor
Qualification	Single line of text	The doctor’s qualifications
RegistrationNumber	Single line of text	The doctor’s unique registration number
DoctorUserPrincipalName	Single line of text	The doctor’s email ID
UpdatedBy	Single line of text	The person that recently updated the record (either the admin or doctor)

3. Hospital List – the hospital list stores information regarding the hospitals

Name of Column	Type	Comment
HospitalName	Single line of text	The name of the hospital
Address	Multiple lines of text	The address of the hospital
HospitalMailId	Single line of text	The mail ID of the hospital
Phone	Single line of text	The telephone number of the hospital
AppLogo	Single line of text	App logo URL of the hospital
EPrescriptionPrefix	Single line of text	Prescription number