## Freelance_Journalists

journalist_id | name | email
--- | --- | ---
1 | John Doe | john@example.com
2 | Jane Smith | jane@example.com
3 | Michael Johnson | michael@example.com
4 | Emily Williams | emily@example.com
5 | David Brown | david@example.com

## Assignments

assignment_id | title | deadline
--- | --- | ---
1 | Feature Stories | 2023-01-15
2 | News Articles | 2023-01-20
3 | Investigative Reports | 2023-01-25
4 | Profile Pieces | 2023-01-30
5 | Opinion Pieces | 2023-02-05

## Publications

publication_id | publication_name | publisher_name
--- | --- | ---
1 | The Daily News | Daily Newspaper Ltd.
2 | The Weekly Times | Weekly Publishing Co.
3 | The Monthly Magazine | Monthly Magazines Inc.
4 | The Annual Review | Annual Reviews Corp.
5 | The Quarterly Report | Quarterly Publishers LLC.

## Article_Publication

article_publication_id | freelance_journalist_id | assignment_id | publication_id | publish_date
--- | --- | --- | --- | ---
| (→ Freelance_Journalists.journalist_id) | (→ Assignments.assignment_id) | (→ Publications.publication_id) |
1 | 1 | 1 | 1 | 2023-01-17
2 | 1 | 2 | 2 | 2023-01-22
3 | 2 | 1 | 3 | 2023-01-26
4 | 2 | 3 | 4 | 2023-02-01
5 | 3 | 2 | 5 | 2023-02-08
6 | 3 | 1 | 5 | 2023-02-08
7 | 4 | 1 | None | None
8 | 5 | 1 | None | None