Database Schema Analysis

**- mhad_patient**
- id
- pregNo - [ patient registration number ]
- fullName
- emailAddress
- phoneNumber
- age
- gender
- username
- password
- dateRegistered
- treatmentStatus [1 - Ongoing, 0 - Treated, 2 - No treatment required]
- assignedDoctorID

**- mhad_patientDiagnosis**
- id
- pregNo
- phqResult
- diagnosisLevel - [M - moderate, S - Severe]
- date Daignosed

**- mhad_patientTreatment**
- id
- pregNo
- targetSymptom - [Sypmtom discovered during further diagnosis]
- tretmentDesc - [What to do and how to doit]
- prescDesc - [Priscription drugs if any]
- dateTreated
- comment
- patientFeedback
- status [1 - Treated, 0 - Ongoin ]

**- mhad_patientSchedule**
- id
- pregNo
- docRegNo
- schDate
- schTime
- schVenue
- schPurpose
- schStatus [1 - don, 0 - pending]
- docComment

**- mhad_patienComplaint**
- id
- pregNo
- assignedDoc
- complainTitle
- complainBody
- complainDate
- complainStatus [1 - treated, 0 - pending]

**- mhad_specialist**
- id
- docRegNo
- fullName
- emailAddress
- password
- occupation [Medical Studen, Nurse, Phamacist, Physician]
- specialty [Pediatricd, Psychiatry, phamacy,orthopedics, Neurology, Dermatology, Critical Care]
- gender
- phoneNumber
- age
- dateRegistered
- activationStatus - [1 - activated, 0 - Pending]
- status

**- mhad_admin**
- id
- admRegNo
- fullName
- emailAddress
- phoneNumber
- password
- role [System Admin, Admin Operator, Executive]

**- mhad_phq_test**
- id
- test_question
- status

**- mhad_phq_answer**
- id
- qid
- answer
- scorevalue [0,1,2,3]
- status

mhad_auditLog
- id
- method
- resources_url
- response_status
- response_time
- access_date
- access_by