Equipment_Type

idname
1DSLR Camera
2Mirrorless Camera
3Camcorder
4Drone
5Action Camera

News_Photography

idphotographer_nameequipment_type_idphoto_titledate_taken
(→ Equipment_Type.id)
1John Doe1Sunset at the Beach2022-06-01
2Jane Smith2City Skyline2022-06-02
3Michael Johnson1Wildlife in Action2022-06-03
4Emma Wilson3Aerial View of Nature Reserve2022-06-04
5David Brown5Surfing Competition2022-06-05

Videography

idvideographer_nameequipment_type_idvideo_titlerelease_dateduration
(→ Equipment_Type.id)
1Tom Miller1Beach Party2022-07-0130:00:00
2Lucy Davis2Fashion Show2022-07-0215:00:00
3Chris Evans3Urban Exploration2022-07-0345:00:00
4Olivia Williams4Birds Eye View2022-07-0420:00:00
5William Jackson5Mountain Biking Adventure2022-07-0525:00:00

Article

idtitlecontentauthor_idpublication_datenews_photography_idvideography_id
(→ Author.id)(→ News_Photography.id)(→ Videography.id)
1Travel Photography TipsLorem ipsum dolor sit amet...12022-08-01NoneNone
2Journalism EthicsLorem ipsum dolor sit amet...22022-08-02NoneNone
3Breaking News CoverageLorem ipsum dolor sit amet...32022-08-031None
4Feature Writing TechniquesLorem ipsum dolor sit amet...42022-08-0423
5Investigative Reporting StrategiesLorem ipsum dolor sit amet...52022-08-0535