Psychologists

idnamespecialtyexperience_yearsclinic
(→ Clinics.name)
1Dr. Jane SmithChild & Adolescent10Harmony Wellness Center
2Dr. John DoeCognitive Behavioral Therapy7Mental Health Solutions

Psychiatrists

idnamespecialtyexperience_yearsclinic
(→ Clinics.name)
1Dr. Alice BrownGeneral Adult8Harmony Wellness Center
2Dr. Bob JohnsonGeriatric9Mental Health Associates

Jobs

idtitledescriptionsalarystart_dateend_datestatus
1PsychologistProviding therapy to children and adolescents.600002023-01-012023-12-31Open
2PsychiatristDiagnosing and treating mental disorders.800002023-01-012023-12-31Open

Applicants

idfirst_namelast_nameemailphone_numberjob_id
(→ Jobs.id)
1JohnDoejohn.doe@example.com555-123-45671
2JaneSmithjane.smith@example.com555-987-65431

Clinics

idnameaddresscitystatezipcode
1Harmony Wellness Center123 Main StAnytownCA12345
2Mental Health Solutions456 Elm StAnother CityNY67890