## Company

id | name
--- | ---
1 | TechCorp
2 | MedWell Inc.
3 | HealthConnect
4 | LifeBalance Solutions
5 | Mindful Care

## Department

id | company_id | department_name
--- | --- | ---
| (→ Company.id) |
1 | 1 | IT
2 | 2 | HR
3 | 3 | Marketing
4 | 4 | Finance
5 | 5 | Operations

## PositionType

id | position_type_name
--- | ---
1 | Full Time
2 | Part Time
3 | Contract
4 | Internship
5 | Freelance

## JobPosting

id | title | description | salary | department_id | position_type_id | start_date | end_date
--- | --- | --- | --- | --- | --- | --- | ---
|  |  |  | (→ Department.id) | (→ PositionType.id) |  |
1 | Software Engineer | Develop software applications. | 70000 | 1 | 1 | 2022-06-01 | 2023-06-01
2 | HR Manager | Manage HR operations. | 60000 | 2 | 1 | 2022-06-01 | 2023-06-01
3 | Digital Marketing Specialist | Create digital marketing strategies. | 50000 | 3 | 1 | 2022-06-01 | 2023-06-01
4 | Financial Analyst | Analyze financial data. | 65000 | 4 | 1 | 2022-06-01 | 2023-06-01
5 | Project Coordinator | Coordinate project activities. | 55000 | 5 | 1 | 2022-06-01 | 2023-06-01

## MentalHealthCareer

id | job_title
--- | ---
1 | Psychologist
2 | Psychiatrist
3 | Occupational Therapist
4 | Mental Health Nurse
5 | Art Therapist

## Clinic

id | clinic_name
--- | ---
1 | Harmony Wellness Center
2 | Peaceful Minds Counseling
3 | Serenity Psychological Services
4 | Innovative Behavioral Health
5 | The Healing Sanctuary

## JobPostingMHC

id | job_posting_id | mental_health_career_id | clinic_id
--- | --- | --- | ---
| (→ JobPosting.id) | (→ MentalHealthCareer.id) | (→ Clinic.id)
1 | 1 | 1 | 1
2 | 2 | 1 | 2
3 | 3 | 2 | 1
4 | 4 | 2 | 3
5 | 5 | 3 | 4