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 |