Photographers

idnameemail
1John Doejohn@example.com
2Jane Smithjane@example.com
3Michael Johnsonmichael@example.com
4Emily Davisemily@example.com
5David Browndavid@example.com

Subjects

idsubject_name
1Portraits
2Landscapes
3Architecture
4Wildlife
5Street Photography

Photographers_Subjects

photographer_idsubject_id
(→ Photographers.id)(→ Subjects.id)
11
21
31
41
51
55