id | name |
---|---|
1 | Harmony Wellness Center |
2 | Sunny Hills Mental Health |
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 |
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 |
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 |
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 |
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 |