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 |
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 |
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 |
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 |