ARMAGEDDON POP

Music Philosophy Art Math Chess Programming and much more ...

May
2
Friday
2025
2025 05 02

Present structure of DB



📦 Table: collections
  • collectionID (PK)
  • Event, Site, EventDate
  • EventSponsor, Section, Stage
  • Mode, Termination
  • Description, created_at
♟️ Table: games
  • ID, ECO (Composite PK)
  • Date (varchar format)
  • White, Black, Result
  • Opening, Variation
  • WhiteClock, BlackClock
  • moves, collectionID
  • SetUp, FEN
🛠️ Table: maintenance
  • ID (PK)
  • tablename, operation
  • startRow, endRow
  • lastUpdate, lastExportTime
  • numberOfRowsInGames
  • numberOfRowsInCollection
  • firstDateInGames, lastDateInGames
👤 Table: players
  • name (PK)
🔎 Indexes: games
  • Primary Key: (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
🗂️ Indexes: other tables
  • collections: collectionID (PK)
  • maintenance: ID (PK)
  • players: name (PK)
📌 Partitioning (games)
  • RANGE by ECO:
    • pA < 'B00'
    • pB < 'C00'
    • pC < 'D00'
    • pD < 'E00'
    • pE < 'F00'
    • pX = MAXVALUE
⚙️ AUTO_INCREMENT
  • games: ID
  • maintenance: ID

Link to ER