| id | name |
|---|---|
| 1 | TechCorp |
| 2 | MedWell Inc. |
| 3 | HealthConnect |
| 4 | LifeBalance Solutions |
| 5 | Mindful Care |
| id | company_id | department_name |
|---|---|---|
| (→ Company.id) | ||
| 1 | 1 | IT |
| 2 | 2 | HR |
| 3 | 3 | Marketing |
| 4 | 4 | Finance |
| 5 | 5 | Operations |
| id | position_type_name |
|---|---|
| 1 | Full Time |
| 2 | Part Time |
| 3 | Contract |
| 4 | Internship |
| 5 | Freelance |
| 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 |
| id | job_title |
|---|---|
| 1 | Psychologist |
| 2 | Psychiatrist |
| 3 | Occupational Therapist |
| 4 | Mental Health Nurse |
| 5 | Art Therapist |
| id | clinic_name |
|---|---|
| 1 | Harmony Wellness Center |
| 2 | Peaceful Minds Counseling |
| 3 | Serenity Psychological Services |
| 4 | Innovative Behavioral Health |
| 5 | The Healing Sanctuary |
| 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 |