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 |
2 |
2017-04-10 |
normal |
2 |
6 |
2017-04-10 |
normal |
2 |
10 |
2017-04-10 |
normal |
2 |
14 |
2017-04-10 |
normal |
2 |
4 |
2017-04-10 |
hard core ! |
4 |
8 |
2017-04-10 |
hard core ! |
4 |
12 |
2017-04-10 |
hard core ! |
4 |
16 |
2017-04-10 |
hard core ! |
4 |
1 |
2017-04-10 |
facile |
1 |
5 |
2017-04-10 |
facile |
1 |
9 |
2017-04-10 |
facile |
1 |
13 |
2017-04-10 |
facile |
1 |
3 |
2017-04-10 |
difficile |
3 |
7 |
2017-04-10 |
difficile |
3 |
11 |
2017-04-10 |
difficile |
3 |
15 |
2017-04-10 |
difficile |
3 |
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 |