id | name |
---|---|
1 | DSLR Camera |
2 | Mirrorless Camera |
3 | Camcorder |
4 | Drone |
5 | Action Camera |
id | photographer_name | equipment_type_id | photo_title | date_taken |
---|---|---|---|---|
(→ Equipment_Type.id) | ||||
1 | John Doe | 1 | Sunset at the Beach | 2022-06-01 |
2 | Jane Smith | 2 | City Skyline | 2022-06-02 |
3 | Michael Johnson | 1 | Wildlife in Action | 2022-06-03 |
4 | Emma Wilson | 3 | Aerial View of Nature Reserve | 2022-06-04 |
5 | David Brown | 5 | Surfing Competition | 2022-06-05 |
id | videographer_name | equipment_type_id | video_title | release_date | duration |
---|---|---|---|---|---|
(→ Equipment_Type.id) | |||||
1 | Tom Miller | 1 | Beach Party | 2022-07-01 | 30:00:00 |
2 | Lucy Davis | 2 | Fashion Show | 2022-07-02 | 15:00:00 |
3 | Chris Evans | 3 | Urban Exploration | 2022-07-03 | 45:00:00 |
4 | Olivia Williams | 4 | Birds Eye View | 2022-07-04 | 20:00:00 |
5 | William Jackson | 5 | Mountain Biking Adventure | 2022-07-05 | 25:00:00 |
id | title | content | author_id | publication_date | news_photography_id | videography_id |
---|---|---|---|---|---|---|
(→ Author.id) | (→ News_Photography.id) | (→ Videography.id) | ||||
1 | Travel Photography Tips | Lorem ipsum dolor sit amet... | 1 | 2022-08-01 | None | None |
2 | Journalism Ethics | Lorem ipsum dolor sit amet... | 2 | 2022-08-02 | None | None |
3 | Breaking News Coverage | Lorem ipsum dolor sit amet... | 3 | 2022-08-03 | 1 | None |
4 | Feature Writing Techniques | Lorem ipsum dolor sit amet... | 4 | 2022-08-04 | 2 | 3 |
5 | Investigative Reporting Strategies | Lorem ipsum dolor sit amet... | 5 | 2022-08-05 | 3 | 5 |