## Formats

id | format_name
--- | ---
1 | Live
2 | Online
3 | Podcast
4 | Video
5 | Magazine

## Broadcasts

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

## Authors

id | name | email
--- | --- | ---
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

## Articles

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

## Comments

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

## Broadcasts_Formats

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