technique_id | technique_name |
---|---|
1 | Manual_Photography |
2 | Landscape_Photography |
3 | Night_Photography |
4 | Wedding_Photography |
5 | Street_Photography |
photographer_id | name | experience |
---|---|---|
1 | John Doe | 8 |
2 | Jane Smith | 6 |
3 | Michael Johnson | 7 |
4 | Emily Davis | 9 |
5 | David Brown | 10 |
session_id | workshop_title | start_time | end_time |
---|---|---|---|
1 | Introduction to Portrait Photography | 2022-01-01 10:00:00 | 2022-01-01 16:00:00 |
2 | Mastering Landscape Photography | 2022-01-02 10:00:00 | 2022-01-02 16:00:00 |
3 | Capturing Night Skies | 2022-01-03 10:00:00 | 2022-01-03 16:00:00 |
4 | Perfecting Wedding Photography | 2022-01-04 10:00:00 | 2022-01-04 16:00:00 |
5 | Urban Exploration Through Street Photography | 2022-01-05 10:00:00 | 2022-01-05 16:00:00 |
id | photography_workshop_id | technique_id |
---|---|---|
(→ Photography_Workshops.workshop_id) | (→ Techniques.technique_id) | |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |
6 | 2 | 1 |
7 | 3 | 1 |
8 | 4 | 1 |
9 | 5 | 1 |
participant_id | first_name | last_name | |
---|---|---|---|
1 | Alice | Smith | alicesmith@example.com |
2 | Bob | Johnson | bobjohnson@example.com |
3 | Carol | Williams | carolwilliams@example.com |
4 | Dave | Brown | davebrown@example.com |
5 | Eve | White | evewhite@example.com |
enrollment_id | participant_id | workshop_session_id |
---|---|---|
(→ Participants.participant_id) | (→ Workshop_Sessions.session_id) | |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |
workshop_id | workshop_leader_id |
---|---|
(→ Photographers.photographer_id) | |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |