## Journalists

id | name | email | language_proficiency | years_experience
--- | --- | --- | --- | ---
1 | John Doe | john@example.com | English | 3
2 | Jane Smith | jane@example.com | French | 6
3 | Alice Johnson | alice@example.com | Spanish | 8
4 | Bob Brown | bob@example.com | German | 7
5 | Carol White | carol@example.com | Italian | 4

## Editors

id | name | email | language_proficiency | experience_years
--- | --- | --- | --- | ---
1 | Michael Jackson | michael@example.com | English | 10
2 | Karen Clark | karen@example.com | Chinese | 9
3 | David Lee | david@example.com | Arabic | 5
4 | Elizabeth Green | elizabeth@example.com | Russian | 8
5 | Frank Miller | frank@example.com | Portuguese | 6

## Companies

id | companyName | location
--- | --- | ---
1 | The New York Times | New York
2 | The Guardian | London
3 | Le Monde | Paris
4 | Der Spiegel | Hamburg
5 | La Repubblica | Milan

## JobPostings

id | jobTitle | description | salary
--- | --- | --- | ---
1 | Reporter | Report on breaking news stories. | 50000
2 | Copy Editor | Check articles for grammar and factual errors. | 55000
3 | Web Producer | Manage website content and social media. | 60000
4 | Investigative Reporter | Conduct in-depth investigations into important issues. | 65000
5 | Photographer | Capture images for publication in print and online. | 52000

## Applications

applicationId | applicantEmail | appliedJob | applyDate
--- | --- | --- | ---
1 | john@example.com | Reporter | 2023-04-17 12:30:00
2 | jane@example.com | Copy Editor | 2023-04-17 12:35:00
3 | alice@example.com | Web Producer | 2023-04-17 12:40:00
4 | bob@example.com | Investigative Reporter | 2023-04-17 12:45:00
5 | carol@example.com | Photographer | 2023-04-17 12:50:00