Freelance_Journalists

journalist_idnameemail
1John Doejohn@example.com
2Jane Smithjane@example.com
3Michael Johnsonmichael@example.com
4Emily Williamsemily@example.com
5David Browndavid@example.com

Assignments

assignment_idtitledeadline
1Feature Stories2023-01-15
2News Articles2023-01-20
3Investigative Reports2023-01-25
4Profile Pieces2023-01-30
5Opinion Pieces2023-02-05

Publications

publication_idpublication_namepublisher_name
1The Daily NewsDaily Newspaper Ltd.
2The Weekly TimesWeekly Publishing Co.
3The Monthly MagazineMonthly Magazines Inc.
4The Annual ReviewAnnual Reviews Corp.
5The Quarterly ReportQuarterly Publishers LLC.

Article_Publication

article_publication_idfreelance_journalist_idassignment_idpublication_idpublish_date
(→ Freelance_Journalists.journalist_id)(→ Assignments.assignment_id)(→ Publications.publication_id)
11112023-01-17
21222023-01-22
32132023-01-26
42342023-02-01
53252023-02-08
63152023-02-08
741NoneNone
851NoneNone