ReporterID | FirstName | LastName | |
---|---|---|---|
1 | John | Doe | john.doe@example.com |
2 | Jane | Smith | jane.smith@example.com |
3 | Michael | Brown | michael.brown@example.com |
4 | Emily | White | emily.white@example.com |
5 | David | Green | david.green@example.com |
ArticleID | Title | Content | PublishDate | AuthorID |
---|---|---|---|---|
(→ Reporters.ReporterID) | ||||
1 | The Importance of Investigative Journalism | Investigative journalism is essential... | 2022-07-01 08:00:00 | 1 |
2 | Climate Change and Its Impact on Society | Climate change has far-reaching effects... | 2022-07-02 10:00:00 | 2 |
3 | Technology Advances in News Reporting | Advances in technology have revolutionized... | 2022-07-03 12:00:00 | 3 |
4 | Coverage of Conflicts Around the World | Journalists play a crucial role in reporting... | 2022-07-04 14:00:00 | 4 |
5 | Freedom of the Press and its Role in Democracy | A free press is vital to maintaining... | 2022-07-05 16:00:00 | 5 |
SourceID | Name | ContactInfo |
---|---|---|
1 | Associated Press | https://www.apnews.com/contact |
2 | Reuters | https://www.reuters.com/contact |
3 | Bloomberg | https://www.bloomberg.com/contact |
4 | CNN | https://edition.cnn.com/contacts |
5 | Al Jazeera | http://www.aljazeera.net/aboutus/contacts |
ArticleSourceID | ArticleID | SourceID | Quote |
---|---|---|---|
(→ Articles.ArticleID) | (→ Sources.SourceID) | ||
1 | 1 | 1 | Quote from Associated Press source |
2 | 2 | 2 | Quote from Reuters source |
3 | 3 | 3 | Quote from Bloomberg source |
4 | 4 | 4 | Quote from CNN source |
5 | 5 | 5 | Quote from Al Jazeera source |
ConferenceID | Date | Time | Location | Subject |
---|---|---|---|---|
1 | 2022-07-06 | 10:00:00 | Washington DC | President's Annual Address |
2 | 2022-07-07 | 14:00:00 | New York City | United Nations Summit |
3 | 2022-07-08 | 16:00:00 | London | G7 Leaders Meeting |
4 | 2022-07-09 | 08:00:00 | Paris | EU Climate Conference |
5 | 2022-07-10 | 12:00:00 | Tokyo | Asia Pacific Economic Cooperation (APEC) |
ReporterAttendeeID | ReporterID | ConferenceID |
---|---|---|
(→ Reporters.ReporterID) | (→ PressConferences.ConferenceID) | |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |