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.

View Schema API Documentation

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