Nurses
NurseID | Name | PatientID | HoursWorked | ExperienceLevel |
1 | Anne Buche | 230 | 8.5 | Intermediate |
2 | John Smith | 367 | 9.0 | Advanced |
3 | Jane Doe | 455 | 7.5 | Beginner |
PhysiciansAssistants
PAID | Name | PatientID | HoursWorked | Specialization |
1 | Anne Buche | 230 | 8.5 | Cardiology |
2 | John Smith | 367 | 9.0 | Gastroenterology |
3 | Jane Doe | 455 | 7.5 | Orthopedics |
Doctors
DoctorID | Name | MedicalLicenseNumber | YearsOfPractice |
1 | Dr. Alice Johnson | M123456 | 10 |
2 | Dr. Bob Brown | B654321 | 15 |
3 | Dr. Carol White | W789012 | 5 |
Clinics
ClinicID | Address | PhoneNumber | NumberofDoctors |
1 | 123 Main St, Anytown | 555-1234 | 3 |
2 | 456 Elm St, Anothertown | 555-5678 | 5 |
Departments
DepartmentID | ClinicID | DepartmentName |
| (→ Clinics.ClinicID) | |
1 | 1 | Family Medicine |
2 | 2 | Dermatology |
Appointment
AppointmentID | DoctorID | Date | ReasonForVisit |
| (→ Doctors.DoctorID) | | |
1 | 1 | 2022-01-01 10:00:00 | Routine checkup |
2 | 2 | 2022-01-02 14:00:00 | Flu shot |
3 | 3 | 2022-01-03 16:00:00 | Skin rash consultation |