Re: [Pypentago-devel] Questions about db structure

[J. K. <ko...@fr...>]

> 1. What is the pgn_string field in GameHistory for if it is not the
> player_name of the winner

I would like to store all the moves of the game in string format in that
field.

The field would use the PGN (portable game notation)  that we agreed upon
a ways back in the mailing list, which I think was:

For example, a chess game can be represented in PGN format:
such as:
1. e4 c5 2. Nf3 d6 3. Bb5+ Bd7 .........  [potentially long string, but
for us it will be much shorter!]

So, for a pypentago PGN, once the game is over, we might have a full string
1. a1,al b1,ar 2. b1,dl d2,dr  ........

That is what I intended the gamehistory.pgn_string field for.




> 2. If the above field is not the player_id of the winner, Shouldn't it be
> there in the game history somewhere ?

Good question.
I was going to assume that the winner of the game was always p1.
But I think I like your direction better.  A new field for "winner_id" or
something?


> 3. I added real_name to the Player structure instead of adding firstname

Sounds good!



> 4. Are we not going to need an Email id for the registration process ? If
> yes, should I add it ?

Yes, yes!


(We have not actually discussed this, but maybe we just all assumed email
address would be in there.)

In fact, maybe we should look at another open source DB structure and make
sure we aren't forgetting other fields needed in the Players table.

A "player_avatar" image blob also sounds potentially useful...

Thanks,

Kovacs