# DB Design
CliniDo Services DB Design [Link](https://dbdiagram.io/d/64bbd53a02bd1c4a5e83efff)
# User Stories
## 1- CliniDo Admin stories
1. As a cliniDo admin i should find a new section in admin panel for Services & Operations.
2. As a cliniDo admin i should view/add/edit/delete ClinicServicesCategory.
- **Inputs:**
- name, name_ar, status
- specialities [ multi select]
- **Outputs:**
- list of ClinicServicesCategories with 3 options [1- view services, 2- edit, 3- activate toggle ]
3. As a cliniDo admin i should view/add/edit/delete ClinicServicesList in side ClinicServicesCategory details page
- **Inputs:**
- clinicservicescategory_id, name, name_ar, status
- image optional [ if found we can use this service as featured card on cliniDo website patient view]
- **Outputs:**
- list of ClinicServicesList with 2 options [1- edit option, 2- activate toggle ]

4. As a CliniDo Admin i should find a list of all ClinicServicesRequests [ Success/noshow+cancel/payable ]

## 2- CliniDo Doctor Stories
1. As a doctor on CliniDo i should login to list/add/edit my ClinicServices
- **Inputs:**
- list of all belong ClinicServicesCategories to my Speciality
- select one of ClinicServicesList then add name,name_ar,description,description_ar,price and optional doctor can make offer on this service with discount amount and start,end date for this offer
- select one or more from my clinics to define the place / time schedule that i will provide my service
- **Outputs:**
- list of doctors' ClinicServices
- list of all ClinicServicesRequests that belong to the doctor
2. As a doctor i should handle all requests on my ClinicServices cancel/noShow/Checkup

## 3- CliniDo CM Polyclinic manager Stories
1. As a CM on CliniDo i should login to list/add/edit my ClinicServices
- **Inputs:**
- list of all belong ClinicServicesCategories to my Specialities (from list of doctors)
- select one of ClinicServicesList then add name,name_ar,description,description_ar,price and optional docot can make offer on this service with discount amount and start,end date for this offer
- select one or more from my clinics to define the place / time schedule that i will provide my service
- **Outputs:**
- list of polyclinic doctors' ClinicServices
- list of all ClinicServicesRequests that belong to the Polyclinic
2. As a CM i should handle all requests on my ClinicServices cancel/noShow/Checkup

## 4- CliniDo Patient Stories
1. As a patient i should find a home screen for CliniDo ClinicServices with all needed sections
- section 1: Search filter [ ClinicServicesCategories / City / Area / keyword 'like service name']
- section 2: featured services with catchy tagline [ get from all ClinicServicesList with image ]
- section 3: to centers/polyclinics that provide a good services
2. As a patient i should see all result for my search query with all needed data to book a service request
3. As a patient i should see ClinicService details page with all data about the service and service provider [ cm/doctor ]
4. As a patient i should book / fill reservation form [ name / mobile ] and got a thank you page with all request details
5. As a patient i should got a sms to confirm my service request with service request details page link
6. As a patient i should edit my reservation cancel/resheduale/rate my reservation
7. As a patient i should see all Doctor/Polyclinic ClinicServices on profile with a new tab for ClinicServices