## 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