Table structure for Games and Moves
Is there a moves table? Is each move stored as a separate record in a table or are they just
appended to a PGN/text/blob field in a games table?
The simple fact that statistics like "average time per move" exist makes me think there might
actually be a table for the moves themselves.
Also, the fact that during analysis or simply clicking through past moves in a game and clicking
several moves down the line, all the pieces go straight for their final destination square.
(Instead of the applet playing through all the moves one by one.) (I know simulating the
moves one by one, getting a resulting FEN and then transforming the board from its current
position to the new one would be entirely possible and if done client-side, not represent any
real strain.) But this feature also makes me wonder if in this 'moves' table there might be an
associated FEN for each record.
I don't know why I'm curious about such a minor detail, but these things pique my curiosity.