Medical Records
*RecordID
AppointmentID
Diagnosis
Treatment
Notes
Record Date
AppointmentTests
Appointment TestID
AppointmentID
TestID
Status
Result
Tests
TestID
Name
Description
Cost
Departments
DepartmentID Name
Location
PhoneNumber
Doctors
DoctorID
FirstName
LastName
PhoneNumber
Email
DepartmentID
Appointments
AppointmentID
PatientID
DoctorID
Patients
PatientID
FirstName
LastName
DateOfBirth
AppointmentDate
Reason
Status
Phone Number
Email
Address
Zoom
+ 100%
Close
