table JOUEUR de la BDD mySQLI
| idJoueur |
nom |
prenom |
ville |
totalPoints |
| 41 |
Alves |
Antony |
Montauban |
666 |
| 16 |
Depredurand |
Elric |
Saint-Gaudens |
132 |
| 2 |
Gebauer |
Max |
Foix |
125 |
| 15 |
Eeckeman |
Florent |
Albi |
63 |
| 1 |
Mendouze |
David |
Toulouse |
48 |
| 9 |
Pierre |
Bertrand |
Albi |
42 |
| 6 |
Delmas |
Cedric |
Decazeville |
36 |
| 10 |
Cordier |
Dorian |
Montauban |
36 |
| 8 |
Bougouin |
Anthony |
Toulouse |
34 |
| 13 |
Abribat |
Arnaud |
Toulouse |
22 |
| 7 |
D'Ancona |
Yoann |
Montauban |
20 |
| 3 |
Mailly |
William |
Foix |
20 |
| 5 |
Alili |
Narimane |
Colomiers |
14 |
| 12 |
Sousa Da Silva |
Joana |
Albi |
14 |
| 14 |
Parent |
Simon |
Castres |
10 |
| 4 |
Alcantara |
Gael |
Foix |
7 |
| 204 |
Bonaud |
Haydar |
Toulouse |
0 |
| 203 |
Foglia |
Julien |
Toulouse |
0 |
| 202 |
ARAGON |
Alban |
Toulouse |
0 |
| 198 |
Parent |
CRÉTEIL |
Balma |
0 |
| 201 |
Roques |
Morgane |
Toulouse |
0 |
| 200 |
Moreno |
juan |
toulouse |
0 |
| 196 |
ALILI |
Narimane |
Colomiers |
0 |
| 195 |
ALILI |
Narimane |
Colomiers |
0 |
| 192 |
ALILI |
Narimane |
Colomiers |
0 |
| 191 |
KKKK |
nnnn |
toulouse |
0 |
| 194 |
ALILI |
Narimane |
Colomiers |
0 |
| 183 |
PIERRE |
Bertrand |
Virac |
0 |
| 177 |
Silva |
Joana |
Albi |
0 |
| 193 |
ALILI |
Narimane |
Colomiers |
0 |
| 123 |
Abribat |
Arnaud |
balma |
0 |
table PARTIE de la BDD mySQLI
| idPartie |
datePartie |
difficulte |
coeffDifficulte |
| 1 |
2017-04-10 |
facile |
1 |
| 2 |
2017-04-10 |
normal |
2 |
| 3 |
2017-04-10 |
difficile |
3 |
| 4 |
2017-04-10 |
hard core ! |
4 |
| 5 |
2017-04-10 |
facile |
1 |
| 6 |
2017-04-10 |
normal |
2 |
| 7 |
2017-04-10 |
difficile |
3 |
| 8 |
2017-04-10 |
hard core ! |
4 |
| 9 |
2017-04-10 |
facile |
1 |
| 10 |
2017-04-10 |
normal |
2 |
| 11 |
2017-04-10 |
difficile |
3 |
| 12 |
2017-04-10 |
hard core ! |
4 |
| 13 |
2017-04-10 |
facile |
1 |
| 14 |
2017-04-10 |
normal |
2 |
| 15 |
2017-04-10 |
difficile |
3 |
| 16 |
2017-04-10 |
hard core ! |
4 |
table relationnelle "jouer" de la BDD mySQLI
| idJoueur |
idPartie |
idTouche |
points |
| 16 |
16 |
1 |
4 |
| 16 |
16 |
2 |
8 |
| 16 |
16 |
1 |
4 |
| 16 |
16 |
1 |
4 |
| 16 |
16 |
1 |
4 |
| 16 |
16 |
2 |
8 |
| 16 |
16 |
2 |
8 |
| 16 |
16 |
3 |
12 |
| 16 |
16 |
1 |
4 |
| 16 |
16 |
1 |
4 |
| 16 |
16 |
3 |
12 |
| 16 |
16 |
1 |
4 |
| 16 |
16 |
3 |
12 |
| 16 |
16 |
3 |
12 |
| 16 |
16 |
2 |
8 |
| 16 |
16 |
4 |
20 |
| 16 |
16 |
1 |
4 |
| 15 |
15 |
1 |
3 |
| 15 |
15 |
1 |
3 |
| 15 |
15 |
2 |
6 |
| 15 |
15 |
4 |
15 |
| 15 |
15 |
2 |
6 |
| 15 |
15 |
4 |
15 |
| 15 |
15 |
4 |
15 |
| 14 |
14 |
1 |
2 |
| 14 |
14 |
3 |
6 |
| 14 |
14 |
1 |
2 |
| 13 |
14 |
2 |
4 |
| 13 |
14 |
2 |
4 |
| 13 |
14 |
1 |
2 |
| 13 |
14 |
3 |
6 |
| 13 |
14 |
3 |
6 |
| 12 |
9 |
1 |
1 |
| 12 |
9 |
1 |
1 |
| 12 |
9 |
3 |
3 |
| 12 |
9 |
1 |
1 |
| 12 |
9 |
1 |
1 |
| 12 |
13 |
4 |
4 |
| 12 |
13 |
1 |
1 |
| 12 |
13 |
2 |
2 |
| 11 |
16 |
1 |
4 |
| 11 |
16 |
2 |
8 |
| 11 |
16 |
3 |
12 |
| 10 |
12 |
2 |
8 |
| 10 |
12 |
2 |
8 |
| 10 |
12 |
2 |
8 |
| 10 |
12 |
2 |
8 |
| 10 |
12 |
1 |
4 |
| 10 |
12 |
4 |
20 |
| 9 |
11 |
3 |
9 |
| 9 |
11 |
1 |
3 |
| 9 |
11 |
3 |
6 |
| 9 |
11 |
4 |
12 |
| 9 |
11 |
2 |
6 |
| 9 |
11 |
2 |
6 |
| 8 |
10 |
2 |
4 |
| 8 |
10 |
2 |
4 |
| 8 |
10 |
1 |
2 |
| 8 |
10 |
2 |
4 |
| 8 |
10 |
2 |
4 |
| 8 |
10 |
4 |
10 |
| 8 |
10 |
3 |
6 |
| 7 |
8 |
1 |
4 |
| 7 |
8 |
2 |
8 |
| 7 |
8 |
2 |
8 |
| 6 |
7 |
4 |
15 |
| 6 |
7 |
2 |
6 |
| 6 |
7 |
1 |
3 |
| 6 |
7 |
1 |
3 |
| 6 |
7 |
3 |
9 |
| 5 |
5 |
1 |
1 |
| 5 |
5 |
2 |
2 |
| 5 |
5 |
4 |
5 |
| 5 |
5 |
2 |
2 |
| 5 |
5 |
2 |
2 |
| 5 |
5 |
2 |
2 |
| 4 |
5 |
3 |
3 |
| 4 |
5 |
1 |
1 |
| 4 |
5 |
3 |
3 |
| 3 |
6 |
2 |
4 |
| 3 |
6 |
2 |
4 |
| 3 |
6 |
2 |
4 |
| 3 |
6 |
1 |
2 |
| 3 |
6 |
3 |
6 |
| 2 |
3 |
1 |
3 |
| 2 |
3 |
1 |
3 |
| 2 |
3 |
2 |
6 |
| 2 |
3 |
4 |
12 |
| 2 |
3 |
3 |
9 |
| 2 |
3 |
3 |
9 |
| 2 |
3 |
1 |
3 |
| 2 |
3 |
3 |
9 |
| 2 |
3 |
2 |
6 |
| 2 |
3 |
2 |
6 |
| 2 |
3 |
2 |
6 |
| 2 |
3 |
1 |
3 |
| 2 |
3 |
4 |
12 |
| 2 |
3 |
1 |
3 |
| 2 |
3 |
1 |
3 |
| 2 |
4 |
3 |
12 |
| 2 |
4 |
1 |
4 |
| 2 |
4 |
2 |
8 |
| 2 |
4 |
2 |
8 |
| 2 |
4 |
1 |
4 |
| 1 |
2 |
1 |
2 |
| 1 |
2 |
2 |
4 |
| 1 |
2 |
2 |
4 |
| 1 |
2 |
1 |
2 |
| 1 |
2 |
1 |
2 |
| 1 |
2 |
3 |
6 |
| 1 |
2 |
2 |
4 |
| 1 |
3 |
1 |
3 |
| 1 |
3 |
1 |
3 |
| 1 |
3 |
2 |
6 |
| 1 |
3 |
2 |
6 |
| 1 |
3 |
2 |
6 |