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 |
id | name | description |
---|---|---|
1 | News | Reporting on current events. |
2 | Features | Investigative journalism and long form articles. |
3 | Opinions | Commentary and editorials. |
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 |
id | firstName | lastName | 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 |
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 |
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 |