Company

idnameaddressphoneNumber
1ABC Corp123 Main St+1234567890
2XYZ Inc.456 Elm St+0987654321
3PQR Ltd.789 Oak St+1357924680

Department

idnamedescription
1NewsReporting on current events.
2FeaturesInvestigative journalism and long form articles.
3OpinionsCommentary and editorials.

MediaJob

idjobTitlelanguageProficiencyexperienceRequiredresponsibilitiesdepartmentId
(→ Department.id)
1JournalistEnglish2Write news stories and reports.1
2JournalistSpanish3Write feature articles and conduct interviews.2
3EditorEnglish5Review and edit content before publication.3
4EditorFrench4Proofread and fact check articles.3

Employee

idfirstNamelastNameemailphoneNumberhireDate
1JohnDoejohn@example.com+11122233342021-01-01
2JaneSmithjane@example.com+44555666772021-02-01
3AliceBrownalice@example.com+77766655542021-03-01
4BobWhitebob@example.com+88899977762021-04-01
5CharlieBlackcharlie@example.com+99988866652021-05-01

Application

applicationIdemployeeIdmediaJobIdapplicationDatestatus
(→ Employee.id)(→ MediaJob.id)
1112021-01-15Pending
2222021-02-15Accepted
3332021-03-15Rejected
4442021-04-15Processing
5552021-05-15Interview Scheduled

Experience

employeeIdcompanyIdpositionstartDateendDate
(→ Employee.id)(→ Company.id)
11Reporter2020-01-01Present
22Feature Writer2019-01-012020-12-31
33Assistant Editor2018-01-012019-12-31
44Subeditor2017-01-012018-12-31
55Managing Editor2016-01-01Present