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