Re: Giant database schema confusion

[lance_cotton]

There cannot be a 'games' table. Or at least I don't know what I'd put in it.

What I need is a Unique-Board-Position table. Each board position must have access to all the moves different players have done from this position in the past (with stats). I think you were thinking of this as an individual game study.

Using your method, would I have a board-position-table with an indexed primary key and a 'moves' table with the moves and the linking p.k. number?

Using this method the 'moves' table will have 2.5 million records per 35000 games and no primary key. Is this the best I can do? (I have 150000 games to deal with!)

_______Unique Board Table______
|P.K| _________________________|
| 1 | A board position ________|
| 2 | Another board position___|
| 3 | Yet another....__________|
_______________________________|

----- Moves Table ------------------------
|F.K|_move____W_____L_____D___|
| 1 | a1-b2 | 7 wins | 0 losses| 3 draws |
| 1 | c4-c6 | 2 wins | 4 losses| 0 draws |
| 1 | d3-g8 | 1 wins | 2 losses| 3 draws |
------------------------------------------


Thanks for your help. I really appreciate your big brain.
Lance