Clinics

idname
1Harmony Wellness Center
2Sunny Hills Mental Health

Psychologists

idclinic_idnamespecialty
(→ Clinics.id)
11Dr. Jane SmithCognitive Behavioral Therapy
22Dr. John BrownExistential Psychotherapy
31Dr. Alice GreenGestalt Therapy
42Dr. Bob WhiteDialectical Behavior Therapy

Psychiatrists

idclinic_idnamespecialty
(→ Clinics.id)
11Dr. Laura BlackAdult Psychiatry
22Dr. Carol BlueChild and Adolescent Psychiatry
31Dr. Emily GrayAddiction Medicine
42Dr. David GoldForensic Psychiatry

Patients

idpsychologist_idpsychiatrist_idnameagediagnosis
(→ Psychologists.id)(→ Psychiatrists.id)
112John Doe30Anxiety Disorder
223Jane Roe28Depression
314Michael Johnson40Bipolar Disorder
421Emily Davis35Schizophrenia
532David Wilson25Autism Spectrum Disorder

Appointments

idpatient_iddatenotes
(→ Patients.id)
112022-09-15 10:00:00First session
222022-09-16 15:00:00Follow-up
332022-09-17 10:30:00Initial assessment
442022-09-18 14:00:00Medication review
552022-09-19 11:00:00Therapy session

TreatmentPlans

idappointment_idplanstatus
(→ Appointments.id)
11Cognitive Behavioral Therapy planIn progress
22Existential Psychotherapy planCompleted
33Gestalt Therapy planOngoing
44Dialectical Behavior Therapy planNot started yet
55Individual therapy planIn progress