1. New patient SQL DB
1.1. tbl_Patient
1.1.1. patientID
1.1.2. intakeDate
1.1.3. owner
1.1.4. kennel
1.1.5. status
1.1.6. group
1.2. tbl_Images
1.3. tbl_Vitals
1.3.1. patientID
1.3.2. pulse
1.3.3. CRT_MM
1.3.4. respiration
1.3.5. weight
1.3.6. exitWeight
1.3.7. lastWalkDate
1.3.8. temperature
1.4. tbl_PhysicalExam
1.5. tbl_Demographics
1.6. tbl_AMPMStatus
1.7. tbl_Tx
1.8. tbl_Exercises
2. New patient UI
2.1. Fill out Form
2.1.1. Cage Card
2.1.1.1. Physical Exam (2)
2.1.1.2. Intake Vitals (1-2)
2.1.1.3. Demographics (2-4)
2.1.1.4. AM/PM Status (2)
2.1.1.5. Exercise (2)
2.1.2. Tx (4)
2.2. Update profile image (4)
2.3. Additional Images of injuries (4 -add on)
2.4. Nice to have
2.4.1. Anesthesia report (8)
2.4.2. PDF Report attached to email (4-6)
2.4.3. Indicator that signals issues (4)
2.4.4. SMS Cumo/Vet (?)
2.4.5. Alert for missed schedules (8)
2.4.6. Test Team members reminders to check on dogs (8)
3. New patient APIs
3.1. Cage Card APIs
3.1.1. Create New Record
3.1.1.1. newPhysicalExamBy(string PatientID, JSON PE)
3.1.1.2. newIntakeVitalsBy(string PatientID, JSON vitals)
3.1.1.3. newDemographicsBy(string PatientID, JSON demographics)
3.1.1.4. newAMPMStatusBy(string PatientID, JSON AMPMStatus)
3.1.2. Update Table
3.1.2.1. updatePhysicalExamBy(string PatientID, JSON PE)
3.1.2.2. updateIntakeVitalsBy(string PatientID, JSON vitals)
3.1.2.3. updateDemographicsBy(string PatientID, JSON demographics)
3.1.2.4. updateAMPMStatusBy(string PatientID, JSON AMPMStatus)
3.2. Tx APIs
3.2.1. newTxBy(string TxID, JSON Tx)
3.2.2. updateTxBy(string TxID, JSON Tx)
3.3. profile or injury image
3.3.1. newImageBy(string type, url imageUrl, int imageID)
3.3.2. updateImageBy(string type, url imageUrl, int imageID)
3.4. Exercies
3.4.1. newExerciseBy(string patientID, JSON exercise)
3.4.2. updateExerciseBY(string patientID, JSON exercise)