Courts_Reporters

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

Trials

idcaseNametrialType
1High_profile_Criminal_Case_1Criminal
2Other_Trial_1Civil
3High_profile_Criminal_Case_2Criminal
4Other_Trial_2Civil
5High_profile_Criminal_Case_3Criminal

Courts_Reporters_Trials

reporterIdtrialId
(→ Courts_Reporters.id)(→ Trials.id)
11
22
33
44
55
16
27
38
49
510
21
31
41
51