Clinics
clinic_id | name | address |
1 | Healthy Living | 123 Main St |
2 | Medical Center | 456 Oak Ave |
3 | Family Care | 789 Pine Blvd |
4 | Northside Hospital | 101 Elm Rd |
5 | Southside Medical | 202 Willow Ln |
Services
service_id | service_name |
1 | Vaccination |
2 | Physical Examination |
3 | Dental Checkup |
4 | Laboratory Tests |
5 | X-ray Imaging |
Clinics_Services
clinics_services_id | clinic_id | service_id |
| (→ Clinics.clinic_id) | (→ Services.service_id) |
1 | 1 | 1 |
2 | 2 | 1 |
3 | 3 | 1 |
4 | 4 | 1 |
5 | 5 | 1 |
6 | 5 | 5 |
Patients
patient_id | first_name | last_name | date_of_birth | phone_number |
1 | John | Smith | 1985-05-15 | 555-123-4567 |
2 | Jane | Doe | 1990-08-20 | 555-987-6543 |
3 | Michael | Brown | 1988-11-22 | 555-345-7890 |
4 | Emily | White | 1992-03-01 | 555-135-7902 |
5 | David | Black | 1986-07-14 | 555-567-8903 |
Appointments
appointment_id | patient_id | clinic_id | service_id | appointment_date |
| (→ Patients.patient_id) | (→ Clinics.clinic_id) | (→ Services.service_id) | |
1 | 1 | 1 | 1 | 2022-01-10 10:00:00 |
2 | 2 | 2 | 3 | 2022-01-12 14:00:00 |
3 | 3 | 3 | 5 | 2022-01-14 09:00:00 |
4 | 4 | 4 | 1 | 2022-01-16 11:00:00 |
5 | 5 | 5 | 4 | 2022-01-18 15:00:00 |