## Reporters

id | name | email | phone_number | address
--- | --- | --- | --- | ---
1 | John Doe | johndoe@example.com | 123-456-7890 | 123 Main St
2 | Jane Smith | janesmith@example.com | 098-765-4321 | 456 Elm St
3 | Alice Johnson | alicejohnson@example.com | 555-555-5555 | 789 Oak St
4 | Bob Brown | bobbrown@example.com | 333-333-3333 | 101 Pine St
5 | Charlie Green | charliegreen@example.com | 222-222-2222 | 111 Maple Ave

## Photographers

id | name | email | phone_number | address
--- | --- | --- | --- | ---
1 | David White | davidwhite@example.com | 444-444-4444 | 234 Birch St
2 | Eva Black | evablack@example.com | 666-666-6666 | 345 Cedar St
3 | Frank Red | frankred@example.com | 777-777-7777 | 456 Walnut St
4 | Grace Blue | graceblue@example.com | 888-888-8888 | 567 Willow St
5 | Hannah Green | hannahgreen@example.com | 999-999-9999 | 678 Sycamore St

## Articles

id | title | content | deadline | reporter_id | photographer_id
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Reporters.id) | (→ Photographers.id)
1 | Article Title 1 | Content of Article 1 | 2020-04-25 | 1 | 1
2 | Article Title 2 | Content of Article 2 | 2020-04-26 | 2 | 2
3 | Article Title 3 | Content of Article 3 | 2020-04-27 | 3 | 3
4 | Article Title 4 | Content of Article 4 | 2020-04-28 | 4 | 4
5 | Article Title 5 | Content of Article 5 | 2020-04-29 | 5 | 5

## Sources

id | name | contact_info | type
--- | --- | --- | ---
1 | Source A | sourcea@example.com | Government Agency
2 | Source B | sourceb@example.com | NGO
3 | Source C | sourcec@example.com | Private Company
4 | Source D | sourced@example.com | Academic Institution
5 | Source E | sourcee@example.com | Journalist Association

## ArticleSources

article_id | source_id | relationship
--- | --- | ---
(→ Articles.id) | (→ Sources.id) |
1 | 1 | Primary Source
1 | 2 | Secondary Source
2 | 3 | Expert Interview
2 | 4 | Background Information
3 | 5 | Press Release

## ReaderComments

comment_id | reader_name | email | comment | article_id
--- | --- | --- | --- | ---
|  |  |  | (→ Articles.id)
1 | Reader 1 | reader1@example.com | Great article! | 1
2 | Reader 2 | reader2@example.com | Interesting perspective. | 2
3 | Reader 3 | reader3@example.com | I disagree with the conclusion. | 3
4 | Reader 4 | reader4@example.com | This is misleading information. | 4
5 | Reader 5 | reader5@example.com | Well-written and informative. | 5