HelpingProfession

ProfessionIDProfessionName
1Social Worker
2Counselor

GeoArea

AreaIDLocationText
1East End
2West Side

Company

CompanyIDNameAddressLine1AddressLine2CityStateZipCodePhoneNumberEmailAddress
1Company A123 Main StNoneCityvilleCA98765123-456-7890companyA@example.com
2Company B456 Elm StNoneDowntownNY12345098-765-4321companyB@example.com

JobPosting

JobIDTitleDescriptionPostedDateDeadlineDateSalaryRangeStatusProfessionIDAreaID
(→ HelpingProfession.ProfessionID)(→ GeoArea.AreaID)
1Social Worker PositionHelp people improve their wellbeing.2024-03-13 12:41:56None$30k-$45kOpen11
2Mental Health CounselorAssist individuals with mental health issues.2024-03-13 12:41:56None$40k-$60kOpen21
3Social Worker PositionHelp people overcome challenges.2024-03-13 12:41:56None$30k-$45kOpen12
4Mental Health CounselorGuide clients towards emotional growth.2024-03-13 12:41:56None$40k-$60kOpen22

Applicant

ApplicantIDFirstNameLastNameDateOfBirthEmailResumePath
1JohnDoe1985-05-15john.doe@email.com/path/to/resume.pdf
2JaneSmith1987-07-23jane.smith@email.com/path/to/resume.pdf

Application

AppIDJobIDApplicantIDSubmissionDateCoverLetterPathStatus
(→ JobPosting.JobID)(→ Applicant.ApplicantID)
1112024-03-13 12:41:56/path/to/coverletter.pdfNone
2222024-03-13 12:41:56/path/to/coverletter.pdfNone