Work location

The worklocation it self is a global entity
A table would need to be created to hold the selected work locations for a single election
WorkLocationElectionEntity
Any one election → Many work locations

Binding/reference tables

• Responsible
  WorklocationResponsibleParticipantEntity
  Any one work location → Many Participants

• Task Types
  WorkLocationTaskTypesEntity
  Any one work location → Many task types

• Team
  WorkLocationTeamEntity
  Any one work location → Many teams

Open

Query examples

• List all work locations in any election

  • Get all WorkLocationElectionEntity in table for the selected election.

• List all teams in any election

  • Get all WorkLocationElectionEntity in table for the selected election.

  • Get all WorkLocationTeamEntity in table for each found WorkLocationElectionEntity

• Get Work location Responsible(s) for all work location in any election

  • Get all WorkLocationElectionEntity in table for the selected election.

  • Get all WorkLocationResponsibleParticipantEntity in table for each found WorkLocationElectionEntity