| journalist_id | name | |
|---|---|---|
| 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 |
| 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 |
| 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_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 |