## Equipment_Type

id | name
--- | ---
1 | DSLR Camera
2 | Mirrorless Camera
3 | Camcorder
4 | Drone
5 | Action Camera

## News_Photography

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

## Videography

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

## Article

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