## Psychologists

id | name | specialty | experience_years | clinic
--- | --- | --- | --- | ---
|  |  |  | (→ Clinics.name)
1 | Dr. Jane Smith | Child & Adolescent | 10 | Harmony Wellness Center
2 | Dr. John Doe | Cognitive Behavioral Therapy | 7 | Mental Health Solutions

## Psychiatrists

id | name | specialty | experience_years | clinic
--- | --- | --- | --- | ---
|  |  |  | (→ Clinics.name)
1 | Dr. Alice Brown | General Adult | 8 | Harmony Wellness Center
2 | Dr. Bob Johnson | Geriatric | 9 | Mental Health Associates

## Jobs

id | title | description | salary | start_date | end_date | status
--- | --- | --- | --- | --- | --- | ---
1 | Psychologist | Providing therapy to children and adolescents. | 60000 | 2023-01-01 | 2023-12-31 | Open
2 | Psychiatrist | Diagnosing and treating mental disorders. | 80000 | 2023-01-01 | 2023-12-31 | Open

## Applicants

id | first_name | last_name | email | phone_number | job_id
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Jobs.id)
1 | John | Doe | john.doe@example.com | 555-123-4567 | 1
2 | Jane | Smith | jane.smith@example.com | 555-987-6543 | 1

## Clinics

id | name | address | city | state | zipcode
--- | --- | --- | --- | --- | ---
1 | Harmony Wellness Center | 123 Main St | Anytown | CA | 12345
2 | Mental Health Solutions | 456 Elm St | Another City | NY | 67890