## Reporters

id | name | email | phone_number | deadline
--- | --- | --- | --- | ---
1 | John Doe | john.doe@example.com | 1234567890 | 2020-04-25
2 | Jane Smith | jane.smith@example.com | 0987654321 | 2020-05-01

## Photographers

id | name | email | phone_number | deadline
--- | --- | --- | --- | ---
1 | Mike Johnson | mike.johnson@example.com | 1112223333 | 2020-04-25
2 | Emily Davis | emily.davis@example.com | 4445556666 | 2020-05-01

## Articles

id | title | content | reporter_id | photographer_id
--- | --- | --- | --- | ---
|  |  | (→ Reporters.id) | (→ Photographers.id)
1 | Article 1 Title | Content of Article 1 | 1 | 1
2 | Article 2 Title | Content of Article 2 | 2 | 2

## Article_Details

id | article_id | source | date
--- | --- | --- | ---
| (→ Articles.id) |  |
1 | 1 | Source A | 2020-04-25 10:00:00
2 | 2 | Source B | 2020-04-25 11:00:00