Photojournalists

idNameBirthdate
1John Doe1980-06-23
2Jane Smith1991-07-05
3Michael Johnson1985-10-02
4Emily Davis1993-01-10
5David Brown1989-05-20

Events

idTitleLocationDate
1Protest RallyDowntown2022-01-01
2Election DayCity Hall2022-11-08
3FestivalPark2022-07-15
4ConcertArena2022-10-20
5MarathonStreets2022-04-10

Photos

idFilePathCaptionTakenOn
1/path/to/photo1.jpgRiot police at protest rally2022-01-01
2/path/to/photo2.jpgVoters waiting to vote2022-11-08
3/path/to/photo3.jpgCrowd enjoying music2022-07-15
4/path/to/photo4.jpgMusician performing on stage2022-10-20
5/path/to/photo5.jpgRunners crossing finish line2022-04-10

PublishedPhotos

idAssignmentIdPhotoIdPublicationDate
(→ Assignments.id)(→ Photos.id)
1112022-01-02
2222022-11-10
3332022-07-20
4442022-10-25
5552022-04-15

Assignments

idOrigin
(→ Events.id)
11
22
33
44
55