## HelpingProfession

ProfessionID | ProfessionName
--- | ---
1 | Social Worker
2 | Counselor

## GeoArea

AreaID | LocationText
--- | ---
1 | East End
2 | West Side

## Company

CompanyID | Name | AddressLine1 | AddressLine2 | City | State | ZipCode | PhoneNumber | EmailAddress
--- | --- | --- | --- | --- | --- | --- | --- | ---
1 | Company A | 123 Main St | None | Cityville | CA | 98765 | 123-456-7890 | companyA@example.com
2 | Company B | 456 Elm St | None | Downtown | NY | 12345 | 098-765-4321 | companyB@example.com

## JobPosting

JobID | Title | Description | PostedDate | DeadlineDate | SalaryRange | Status | ProfessionID | AreaID
--- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  |  | (→ HelpingProfession.ProfessionID) | (→ GeoArea.AreaID)
1 | Social Worker Position | Help people improve their wellbeing. | 2024-03-13 12:41:56 | None | $30k-$45k | Open | 1 | 1
2 | Mental Health Counselor | Assist individuals with mental health issues. | 2024-03-13 12:41:56 | None | $40k-$60k | Open | 2 | 1
3 | Social Worker Position | Help people overcome challenges. | 2024-03-13 12:41:56 | None | $30k-$45k | Open | 1 | 2
4 | Mental Health Counselor | Guide clients towards emotional growth. | 2024-03-13 12:41:56 | None | $40k-$60k | Open | 2 | 2

## Applicant

ApplicantID | FirstName | LastName | DateOfBirth | Email | ResumePath
--- | --- | --- | --- | --- | ---
1 | John | Doe | 1985-05-15 | john.doe@email.com | /path/to/resume.pdf
2 | Jane | Smith | 1987-07-23 | jane.smith@email.com | /path/to/resume.pdf

## Application

AppID | JobID | ApplicantID | SubmissionDate | CoverLetterPath | Status
--- | --- | --- | --- | --- | ---
| (→ JobPosting.JobID) | (→ Applicant.ApplicantID) |  |  |
1 | 1 | 1 | 2024-03-13 12:41:56 | /path/to/coverletter.pdf | None
2 | 2 | 2 | 2024-03-13 12:41:56 | /path/to/coverletter.pdf | None