Data Stores - OfficeDev/microsoft-teams-apps-eprescription GitHub Wiki
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:
- 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 |
| 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 |
- 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) |
- 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 |