Political_Reporters

idnameemail
1John Doejohn@example.com
2Jane Smithjane@example.com
3Alice Johnsonalice@example.com
4Bob Brownbob@example.com
5Charlie Greencharlie@example.com

Elections

idelection_typestart_dateend_date
1Presidential_Campaigns2021-01-012021-12-31
2Local_Council_elections2022-01-012022-12-31
3State_Assembly_elections2023-01-012023-12-31
4Referendums2024-01-012024-12-31
5By-Elections2025-01-012025-12-31

Political_Reporters_Elections

reporter_idelection_id
(→ Political_Reporters.id)(→ Elections.id)
11
12
21
23
31
41
51