Company

idname
1TechCorp
2MedWell Inc.
3HealthConnect
4LifeBalance Solutions
5Mindful Care

Department

idcompany_iddepartment_name
(→ Company.id)
11IT
22HR
33Marketing
44Finance
55Operations

PositionType

idposition_type_name
1Full Time
2Part Time
3Contract
4Internship
5Freelance

JobPosting

idtitledescriptionsalarydepartment_idposition_type_idstart_dateend_date
(→ Department.id)(→ PositionType.id)
1Software EngineerDevelop software applications.70000112022-06-012023-06-01
2HR ManagerManage HR operations.60000212022-06-012023-06-01
3Digital Marketing SpecialistCreate digital marketing strategies.50000312022-06-012023-06-01
4Financial AnalystAnalyze financial data.65000412022-06-012023-06-01
5Project CoordinatorCoordinate project activities.55000512022-06-012023-06-01

MentalHealthCareer

idjob_title
1Psychologist
2Psychiatrist
3Occupational Therapist
4Mental Health Nurse
5Art Therapist

Clinic

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

JobPostingMHC

idjob_posting_idmental_health_career_idclinic_id
(→ JobPosting.id)(→ MentalHealthCareer.id)(→ Clinic.id)
1111
2212
3321
4423
5534