Public_Relations

idcontactdepartmentroleemailphonedescription
1BBCNews AgencyPR Managerbbc@email.com123-456-7890Manages PR for BBC News
2CNNNews AgencyDirector of Communicationscnn@email.com987-654-3210Oversees communications strategy for CNN

Government_Communications

idcontactdepartmentroleemailphonedescription
1WhiteHouseExecutive BranchPress Secretarywhitehouse@email.gov555-123-4567Spokesperson for the White House
2StateDeptExecutive BranchDeputy Spokesmanstatedept@email.gov555-987-6543Assists the Press Secretary at State Department

Contacts

idnameorganizationpublic_relations_idgovernment_communications_id
(→ Public_Relations.id)(→ Government_Communications.id)
1John DoeABC News1None
2Jane SmithFox News21
3Alice BrownNBC NewsNone2

Articles

idtitlecontentpublished_dateauthor_id
(→ Authors.id)
1Article 1Content for Article 1...2022-01-01 10:00:001
2Article 2Content for Article 2...2022-01-02 10:00:002

Authors

idnameorganizationpublic_relations_contact_idgovernment_communications_contact_id
(→ Contacts.public_relations_id)(→ Contacts.government_communications_id)
1Michael JohnsonThe Guardian11
2Emma DavisThe New York Times22

Sources

idnametypesource_urlarticle_id
(→ Articles.id)
1Source 1Websitehttps://www.source1.com/article1
2Source 2Newspaperhttp://newspaper.com/article2