War_Correspondents
id | name | organization |
1 | John Smith | ABC News |
2 | Jane Doe | CNN |
3 | Michael Brown | Fox News |
4 | Emily Johnson | BBC |
5 | David Wilson | Al Jazeera |
Locations
id | locationName |
1 | Battlefield |
2 | Capital City |
3 | Refugee Camp |
4 | Military Base |
5 | Government Building |
War_Correspondents_Locations
warCorrespondentId | locationId | assignmentDate |
(→ War_Correspondents.id) | (→ Locations.id) | |
1 | 1 | 2023-01-01 |
1 | 2 | 2023-02-01 |
2 | 1 | 2023-03-01 |
2 | 3 | 2023-04-01 |
3 | 2 | 2023-05-01 |
3 | 4 | 2023-06-01 |
4 | 1 | 2023-07-01 |
4 | 5 | 2023-08-01 |
5 | 3 | 2023-09-01 |
5 | 4 | 2023-10-01 |
3 | 1 | 2023-05-01 |
5 | 1 | 2023-09-01 |