Public_Relations

idorganizationcontactsdescriptioncreated_at
1BBC+1234567890A leading global broadcasting corporation2024-03-13 18:14:54
2CNN+9876543210An American basic cable and satellite television news channel2024-03-13 18:14:54

Government_Communications

idgovernment_agencycontactsdescriptioncreated_at
1White House+0987654321The official residence and workplace of the President of the United States2024-03-13 18:14:54
2Department of State+1234567890U.S. Department responsible for international relations2024-03-13 18:14:54

News_Articles

idtitlecontentauthor_idpublication_datepublic_relations_contact_id
(→ Authors.id)(→ Public_Relations.id)
1Test Title 1This is a test content.12024-03-13 18:14:541
2Test Title 2This is another test content.22024-03-13 18:14:542

Authors

idnameemailphone_number
1John Doejohndoe@example.com+1234567890
2Jane Smithjanesmith@example.com+0987654321

Sources

idsource_namecontact_details
1Reutersreuters@example.com
2Associated Pressap@example.com

Article_Sources

article_idsource_id
(→ News_Articles.id)(→ Sources.id)
11
22