## Photojournalists

id | Name | Birthdate
--- | --- | ---
1 | John Doe | 1980-06-23
2 | Jane Smith | 1991-07-05
3 | Michael Johnson | 1985-10-02
4 | Emily Davis | 1993-01-10
5 | David Brown | 1989-05-20

## Events

id | Title | Location | Date
--- | --- | --- | ---
1 | Protest Rally | Downtown | 2022-01-01
2 | Election Day | City Hall | 2022-11-08
3 | Festival | Park | 2022-07-15
4 | Concert | Arena | 2022-10-20
5 | Marathon | Streets | 2022-04-10

## Photos

id | FilePath | Caption | TakenOn
--- | --- | --- | ---
1 | /path/to/photo1.jpg | Riot police at protest rally | 2022-01-01
2 | /path/to/photo2.jpg | Voters waiting to vote | 2022-11-08
3 | /path/to/photo3.jpg | Crowd enjoying music | 2022-07-15
4 | /path/to/photo4.jpg | Musician performing on stage | 2022-10-20
5 | /path/to/photo5.jpg | Runners crossing finish line | 2022-04-10

## Assignments

id | EventId | PhotojournalistId
--- | --- | ---
| (→ Events.id) | (→ Photojournalists.id)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
5 | 5 | 5

## PublishedPhotos

id | AssignmentId | PhotoId | PublicationDate
--- | --- | --- | ---
| (→ Assignments.id) | (→ Photos.id) |
1 | 1 | 1 | 2022-01-02
2 | 2 | 2 | 2022-11-10
3 | 3 | 3 | 2022-07-20
4 | 4 | 4 | 2022-10-25
5 | 5 | 5 | 2022-04-15