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