Skip to content

Instantly share code, notes, and snippets.

@EduardoRFS
Created September 3, 2019 00:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save EduardoRFS/d37c343cd4602be158ab8af56064de86 to your computer and use it in GitHub Desktop.
Save EduardoRFS/d37c343cd4602be158ab8af56064de86 to your computer and use it in GitHub Desktop.

tb_partida

id vencedor
0 1
1 2

tb_time

id_partida id_time nome
0 0 Azul
0 1 Vermelho
1 0 Azul
1 1 Vermelho
1 2 Verde

tb_jogador

id_partida id_time id_jogador nome status
0 0 0 Eduardo 1
0 0 1 Moorte 0
0 1 0 Xunjin 1
1 0 0 Xunjin 1
1 1 0 Roupi 1
1 2 0 Eduardo 1
{
  "id": 0,
  "vencedor": 1,
  "times": [
    {
      "id": 0,
      "jogadores": [
        {
          "id": 0,
          "nome": "Eduardo",
          "status": 1
        },
        {
          "id": 1,
          "nome": "Moorte",
          "status": 0
        }
      ]
    },
    {
      "id": 1,
      "jogadores": ["Xunjin"]
    }
  ]
}
@TopRoupi
Copy link

TopRoupi commented Sep 3, 2019

ninja

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment