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 |