Teams

Owned by Dan Nobel
May 31, 2023
1 min read

The Team it self is a global entity.
A team is bound to one or more Work locations
it

Binding/reference tables

  • Responsible
    TeamResponsibles
    Any one Team → Many Participants

  • TeamMembers
    Any one Team → Many Participants

  • Worklocation
    WorkLocationTeamEntity
    Any one work location → Many teams

Query examples

  • 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 Team members for any team on any work location in any election

    • Get all WorkLocationElectionEntity in table for the selected election.

    • Get all WorkLocationTeamMemberEntity in table for each found WorkLocationElectionEntity

    • Get ParticipantEntities.