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 |
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 |
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 |
id | EventId | PhotojournalistId |
---|---|---|
(→ Events.id) | (→ Photojournalists.id) | |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |
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 |