Database Schema

For our own reference:

Leagues

• <leagueId1>: generated on push
  • name: "Newly Created League"
  • users:
    • <userId1>: true creator
    • <userId2>: false invited opponent
• <leagueId2>:
  • name: "League With Playlists"
    • <userId1>:
      • <songId1>: true
      • <songId3>: true
      • <songId5>: true
    • <userId2>:
      • <songId2>: true
      • <songId4>: true
      • <songId6>: true

Songs

• <songId1>: spotify track id
  • artist: "Song 1 Artist"
  • name: "Song 1"
  • leagues: leagues that have this song in a playlist
    • <leagueId2>: true

SongStats

• <songStatId1>: generated on push
  • date: "2016-01-01"
  • songId: "<songId1>"
  • popularity: 70

UserProfiles

• <userId1>: spotify user id
  • dateCreated: "2016-11-17T17:16:58.145Z"
  • leagues:
    • <leagueId1>: true
    • <leagueId2>: true
• <userId2>:
  • dateCreated: "2016-11-17T17:16:58.145Z"
  • leagues:
    • <leagueId1>: false invited to league
    • <leagueId2>: true
• <userId3>: newly created user
  • dateCreated: "2016-11-17T17:16:58.145Z"