| 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 |