## reporters

id | name | role | deadline | assigned_newsroom
--- | --- | --- | --- | ---
|  |  |  | (→ newsrooms.id)
1 | John Doe | Reporter | 2021-03-18 16:39:07 | 1
2 | Jane Smith | Reporter | 2021-03-22 16:39:07 | 2
3 | Mike Johnson | Photographer | 2021-03-18 16:39:07 | 3
4 | Anna Brown | Photographer | 2021-03-22 16:39:07 | 4

## storyIdeas

id | title | description | pitchDate | assignedTo | status
--- | --- | --- | --- | --- | ---
|  |  |  | (→ reporters.id) |
1 | Climate Change Impact | Impact of climate change on coastal cities | 2021-03-15 16:39:07 | 1 | None
2 | Technology Advancement | Latest advancements in artificial intelligence | 2021-03-15 16:39:07 | 2 | None
3 | Covid Vaccine Rollout | Global rollout of Covid vaccine | 2021-03-15 16:39:07 | 3 | None
4 | Space Exploration | Recent achievements in space exploration | 2021-03-15 16:39:07 | 4 | None
5 | Economic Recovery | Strategies for economic recovery post pandemic | 2021-03-15 16:39:07 | 5 | None

## publications

id | title | content | publishDate | associatedStoryId
--- | --- | --- | --- | ---
|  |  |  | (→ storyIdeas.id)
1 | The Climate Crisis | Effects of climate change on human life... | 2021-03-16 16:39:07 | 1
2 | AI Revolution | Artificial Intelligence has changed our lives like never before... | 2021-03-16 16:39:07 | 2
3 | Vaccination Drive | How the global vaccination drive against COVID... | 2021-03-16 16:39:07 | 3
4 | New Horizons in Space | Astronomers have discovered new celestial bodies... | 2021-03-16 16:39:07 | 4
5 | Post Pandemic Economy | What does a post-COVID economy look like? ... | 2021-03-16 16:39:07 | 5

## readershipStats

id | publicationId | numPageViews | avgTimeSpentReading
--- | --- | --- | ---
| (→ publications.id) |  |
1 | 1 | 200 | 10
2 | 2 | 400 | 20
3 | 3 | 150 | 5
4 | 4 | 300 | 15
5 | 5 | 250 | 12