Pokemon_Sun_And_Moon_Complete_Datamodel

Pokémon Sun & Moon – Complete Data Model (README)

This document defines a complete data model (schema + examples) for representing all Pokémon Sun & Moon data. You can directly copy–paste this into a README.md (e.g., for GitHub or Hugging Face).

---

📌 Overview

This data model is designed to store all relevant Pokémon information for Pokémon Sun & Moon (Generation 7), including:

Pokémon basic information

Types

Base stats

Abilities (including Hidden Abilities)

Moves

Learnsets (Level-up, TM, Egg, Tutor)

Evolutions

Items

TMs / TRs

The model is database-friendly, CSV/JSON compatible, and can be adapted for APIs, ML datasets, or game analysis.

---

🧱 Database Schema

1️⃣ Pokémon Table

Stores the core Pokémon identity and physical data.

Field Type Description

id INT Internal Pokémon ID national_number VARCHAR National Pokédex number name VARCHAR Pokémon name species VARCHAR Species name form_name VARCHAR Form name (Alolan, Totem, etc.) generation INT Generation number (7) height_dm FLOAT Height in decimeters weight_hg FLOAT Weight in hectograms color VARCHAR Pokédex color base_experience INT Base experience yield

Example

id national_number name species form_name generation

25 025 Pikachu Mouse Pokémon Alolan Cap 7

---

2️⃣ Types Table

A Pokémon can have one or two types.

Field Type Description

pokemon_id INT Foreign key → Pokémon.id type VARCHAR Pokémon type (Fire, Water, etc.)

Example

pokemon_id type

25 Electric

---

3️⃣ Base Stats Table

Stores base battle stats.

Field Type Description

pokemon_id INT Foreign key hp INT Base HP attack INT Base Attack defense INT Base Defense sp_attack INT Base Special Attack sp_defense INT Base Special Defense speed INT Base Speed

Example

pokemon_id hp attack defense sp_attack sp_defense speed

25 35 55 40 50 50 90

---

4️⃣ Abilities Table

Includes normal and hidden abilities.

Field Type Description