articleID | title | authorName | publishDate | content |
---|---|---|---|---|
1 | Britain Is Cutting Taxes Again. Why Now? | John Doe | 2021-08-31 16:00:00 | This is an important piece of news... |
2 | Global Warming: The Human Impact | Jane Smith | 2021-09-01 17:00:00 | An insightful look at global warming caused by human activities... |
pressReleaseID | title | releaseDate | content | FK_articleID |
---|---|---|---|---|
(→ Articles.articleID) | ||||
1 | Q2 Earnings Report | 2021-08-31 18:00:00 | Our Q2 earnings report showcases ... | 1 |
2 | Annual General Meeting Announcement | 2021-09-01 19:00:00 | We invite our shareholders to attend our annual general meeting on September 15th. | 2 |
interviewID | intervieweeName | interviewerName | interviewDate | content | FK_articleID |
---|---|---|---|---|---|
(→ Articles.articleID) | |||||
1 | Mark Johnson | Emily Brown | 2021-08-31 20:00:00 | Mr. Mark Johnson shared his insights about the tax cuts... | 1 |
2 | Linda Davis | Michael White | 2021-09-01 21:00:00 | Ms. Linda Davis discussed her views on climate change... | 2 |
sourceID | name | description | contactInfo |
---|---|---|---|
1 | New York Times | A leading daily newspaper founded in 1851... | +1 212-555-6789 |
2 | Washington Post | Founded in 1877, it is one of the largest newspapers in the US... | +1 202-334-6000 |