## Clinics

id | name
--- | ---
1 | Harmony Wellness Center
2 | Sunny Hills Mental Health

## Psychologists

id | clinic_id | name | specialty
--- | --- | --- | ---
| (→ Clinics.id) |  |
1 | 1 | Dr. Jane Smith | Cognitive Behavioral Therapy
2 | 2 | Dr. John Brown | Existential Psychotherapy
3 | 1 | Dr. Alice Green | Gestalt Therapy
4 | 2 | Dr. Bob White | Dialectical Behavior Therapy

## Psychiatrists

id | clinic_id | name | specialty
--- | --- | --- | ---
| (→ Clinics.id) |  |
1 | 1 | Dr. Laura Black | Adult Psychiatry
2 | 2 | Dr. Carol Blue | Child and Adolescent Psychiatry
3 | 1 | Dr. Emily Gray | Addiction Medicine
4 | 2 | Dr. David Gold | Forensic Psychiatry

## Patients

id | psychologist_id | psychiatrist_id | name | age | diagnosis
--- | --- | --- | --- | --- | ---
| (→ Psychologists.id) | (→ Psychiatrists.id) |  |  |
1 | 1 | 2 | John Doe | 30 | Anxiety Disorder
2 | 2 | 3 | Jane Roe | 28 | Depression
3 | 1 | 4 | Michael Johnson | 40 | Bipolar Disorder
4 | 2 | 1 | Emily Davis | 35 | Schizophrenia
5 | 3 | 2 | David Wilson | 25 | Autism Spectrum Disorder

## Appointments

id | patient_id | date | notes
--- | --- | --- | ---
| (→ Patients.id) |  |
1 | 1 | 2022-09-15 10:00:00 | First session
2 | 2 | 2022-09-16 15:00:00 | Follow-up
3 | 3 | 2022-09-17 10:30:00 | Initial assessment
4 | 4 | 2022-09-18 14:00:00 | Medication review
5 | 5 | 2022-09-19 11:00:00 | Therapy session

## TreatmentPlans

id | appointment_id | plan | status
--- | --- | --- | ---
| (→ Appointments.id) |  |
1 | 1 | Cognitive Behavioral Therapy plan | In progress
2 | 2 | Existential Psychotherapy plan | Completed
3 | 3 | Gestalt Therapy plan | Ongoing
4 | 4 | Dialectical Behavior Therapy plan | Not started yet
5 | 5 | Individual therapy plan | In progress