Back to Documentation

Database Schema Documentation

Comprehensive documentation of our Pokemon API database schema, data structures, field types, and relationships. Understand how data is organized for effective Pokemon card API integration.

Database Schema Overview

Core Entities

Cards, Sets, Prices, and Grading data with normalized relationships

Unique Identifiers

Consistent ID format across all entities for easy referencing

Indexed Fields

Optimized for fast queries on names, sets, prices, and dates

Entity Relationships

Sets

  • • id (Primary Key)
  • • name
  • • releaseDate
  • • total
←→

Cards

  • • id (Primary Key)
  • • setId (Foreign Key)
  • • name
  • • number

Price Data

  • • cardId (Foreign Key)
  • • market, low, high
  • • lastUpdated
  • • source

Graded Prices

  • • cardId (Foreign Key)
  • • grade, condition
  • • price
  • • population

Detailed Data Structures

Cards Collection Schema

{
  "id": "base1-4",                    // Unique identifier (setId-number)
  "name": "Charizard",               // Card name
  "supertype": "Pokémon",            // Card supertype
  "subtypes": ["Stage 2"],           // Array of subtypes
  "hp": "120",                       // Hit points (string or null)
  "types": ["Fire"],                 // Array of Pokemon types
  "rarity": "Rare Holo",             // Card rarity
  "artist": "Mitsuhiro Arita",       // Card artist
  "number": "4",                     // Card number in set
  "set": {
    "id": "base1",                   // Set identifier
    "name": "Base Set",              // Set name
    "series": "Base"                 // Series name
  },
  "images": {
    "small": "https://...",          // Small image URL (245x342)
    "large": "https://..."           // Large image URL (734x1024)
  },
  "tcgplayer": {
    "url": "https://...",            // TCGPlayer product URL
    "updatedAt": "2025-01-10",       // Last price update
    "prices": {
      "holofoil": {
        "low": 275.00,               // Lowest price
        "mid": 375.00,               // Mid price
        "high": 575.00,              // Highest price
        "market": 399.99             // Market price
      }
    }
  },
  "gradedPrices": {
    "psa10": 15750.00,               // PSA 10 price
    "psa9": 1850.00,                 // PSA 9 price
    "psa8": 750.00                   // PSA 8 price
  },
  "lastUpdated": "2025-01-10T12:00:00Z"
}

Primary Fields:

  • String
    id: Unique identifier (setId-number)
  • String
    name: Card name (indexed)
  • String
    rarity: Card rarity level
  • Array
    types: Pokemon types
  • Object
    set: Set information

Price Fields:

  • Object
    tcgplayer: TCGPlayer pricing
  • Object
    cardmarket: European prices
  • Object
    ebay: eBay sold listings
  • Object
    gradedPrices: Graded card values
  • Array
    priceHistory: Historical data

Ready to Integrate with Our Database?

Start building applications with comprehensive Pokemon card data and pricing information