Music Philosophy Art Math Chess Programming and much more ...
collectionID
(PK)Event
, Site
, EventDate
EventSponsor
, Section
, Stage
Mode
, Termination
Description
, created_at
ID
, ECO
(Composite PK)Date
(varchar format)White
, Black
, Result
Opening
, Variation
WhiteClock
, BlackClock
moves
, collectionID
SetUp
, FEN
ID
(PK)tablename
, operation
startRow
, endRow
lastUpdate
, lastExportTime
numberOfRowsInGames
numberOfRowsInCollection
firstDateInGames
, lastDateInGames
name
(PK)(ID, ECO)
idx_eco
, idx_date
idx_collection
idx_white
, idx_black
idx_white_black
idx_white_eco
, idx_black_eco
idx_white_collection
, idx_black_collection
collectionID
(PK)ID
(PK)name
(PK)ECO
:
pA
< 'B00'pB
< 'C00'pC
< 'D00'pD
< 'E00'pE
< 'F00'pX
= MAXVALUEID
ID