## Company

id | name | address | phoneNumber
--- | --- | --- | ---
1 | ABC Corp | 123 Main St | +1234567890
2 | XYZ Inc. | 456 Elm St | +0987654321
3 | PQR Ltd. | 789 Oak St | +1357924680

## Department

id | name | description
--- | --- | ---
1 | News | Reporting on current events.
2 | Features | Investigative journalism and long form articles.
3 | Opinions | Commentary and editorials.

## MediaJob

id | jobTitle | languageProficiency | experienceRequired | responsibilities | departmentId
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Department.id)
1 | Journalist | English | 2 | Write news stories and reports. | 1
2 | Journalist | Spanish | 3 | Write feature articles and conduct interviews. | 2
3 | Editor | English | 5 | Review and edit content before publication. | 3
4 | Editor | French | 4 | Proofread and fact check articles. | 3

## Employee

id | firstName | lastName | email | phoneNumber | hireDate
--- | --- | --- | --- | --- | ---
1 | John | Doe | john@example.com | +1112223334 | 2021-01-01
2 | Jane | Smith | jane@example.com | +4455566677 | 2021-02-01
3 | Alice | Brown | alice@example.com | +7776665554 | 2021-03-01
4 | Bob | White | bob@example.com | +8889997776 | 2021-04-01
5 | Charlie | Black | charlie@example.com | +9998886665 | 2021-05-01

## Application

applicationId | employeeId | mediaJobId | applicationDate | status
--- | --- | --- | --- | ---
| (→ Employee.id) | (→ MediaJob.id) |  |
1 | 1 | 1 | 2021-01-15 | Pending
2 | 2 | 2 | 2021-02-15 | Accepted
3 | 3 | 3 | 2021-03-15 | Rejected
4 | 4 | 4 | 2021-04-15 | Processing
5 | 5 | 5 | 2021-05-15 | Interview Scheduled

## Experience

employeeId | companyId | position | startDate | endDate
--- | --- | --- | --- | ---
(→ Employee.id) | (→ Company.id) |  |  |
1 | 1 | Reporter | 2020-01-01 | Present
2 | 2 | Feature Writer | 2019-01-01 | 2020-12-31
3 | 3 | Assistant Editor | 2018-01-01 | 2019-12-31
4 | 4 | Subeditor | 2017-01-01 | 2018-12-31
5 | 5 | Managing Editor | 2016-01-01 | Present