ProfessionID | ProfessionName |
---|---|
1 | Social Worker |
2 | Counselor |
AreaID | LocationText |
---|---|
1 | East End |
2 | West Side |
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 |
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 |
ApplicantID | FirstName | LastName | DateOfBirth | 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 |
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 |