id | format_name |
---|---|
1 | Live |
2 | Online |
3 | Podcast |
4 | Video |
5 | Magazine |
id | title | date |
---|---|---|
1 | Tonight's Live News Coverage | 2023-04-01 18:00:00 |
2 | Weekly Podcast: Current Affairs | 2023-04-06 09:00:00 |
3 | Daily Online Newspaper Update | 2023-04-07 12:00:00 |
4 | Monthly Video Magazine Issue | 2023-04-15 17:00:00 |
5 | Breaking News Special | 2023-04-20 15:00:00 |
id | name | |
---|---|---|
1 | John Doe | john@example.com |
2 | Jane Smith | jane@example.com |
3 | Mike Johnson | mike@example.com |
4 | Emily Davis | emily@example.com |
5 | David Brown | david@example.com |
id | title | content | publish_date | author_id |
---|---|---|---|---|
(→ Authors.id) | ||||
1 | The Importance of Journalistic Integrity | Journalism plays a critical role in society... | 2024-01-30 18:51:09 | 1 |
2 | Investigative Reporting Techniques | A look at some effective techniques used by investigative reporters... | 2024-01-30 18:51:09 | 2 |
3 | Impact of Social Media on News Consumption | How social media has changed the way people consume news... | 2024-01-30 18:51:09 | 3 |
4 | Censorship and Freedom of the Press | Examining the issue of censorship and its impact on freedom of the press... | 2024-01-30 18:51:09 | 4 |
5 | The Future of Print Journalism | Can print journalism survive in the digital age? | 2024-01-30 18:51:09 | 5 |
id | comment | article_id |
---|---|---|
(→ Articles.id) | ||
1 | Great article! Very informative. | 1 |
2 | I agree completely - it's essential that journalists maintain their integrity. | 1 |
3 | This is an interesting perspective on how social media affects news consumption. | 3 |
4 | Important topic, but I think there should also be a discussion about self-censorship. | 4 |
5 | Print journalism will always have a place as long as there is a demand for quality reporting. | 5 |
broadcast_id | format_id |
---|---|
(→ Broadcasts.id) | (→ Formats.id) |
1 | 5 |
1 | 2 |
2 | 3 |
3 | 2 |
4 | 4 |
5 | 5 |
2 | 5 |
3 | 5 |
4 | 5 |