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 |