DDL:/db/ddl/ddl-*.sql

2022/08/12現在

ER図

classDiagram
direction BT
class abilities {
   integer id
   varchar(20) name
}
class game_versions {
   integer id
   varchar(30) name
   integer gen
}
class goods {
   integer id
   varchar(20) name
}
class grown_pokemons {
   integer id
   integer pokemon
   integer good
   integer ability
   integer nature
   integer move1
   integer move2
   integer move3
   integer move4
   integer evH
   integer evA
   integer evB
   integer evC
   integer evD
   integer evS
   integer ivH
   integer ivA
   integer ivB
   integer ivC
   integer ivD
   integer ivS
   boolean isShiny
   text comment
   integer user
}
class move_selects {
   integer id
   varchar(10) name
}
class moves {
   integer id
   varchar(30) name
   integer select
   integer type
   integer damage
}
class natures {
   integer id
   varchar(10) name
   boolean is_majime
   integer up
   integer down
}
class pokemon_ability_map {
   integer id
   integer pokemon
   integer ability
   boolean is_hidden
}
class pokemon_build_map {
   integer id
   integer build
   integer pokemon
   boolean isActive
   text comment
}
class pokemon_builds {
   integer id
   varchar(100) name
   text comment
   integer user
}
class pokemon_move_map {
   integer id
   integer pokemon
   integer move
   integer version
}
class pokemon_tag_map {
   integer id
   integer pokemon
   integer tag
}
class pokemon_tags {
   integer id
   varchar(15) name
   varchar(50) color
}
class pokemon_type_map {
   integer id
   integer pokemon
   integer type
}
class pokemons {
   integer id
   varchar(10) name
   varchar(20) form_name
   integer dex_no
   integer form_no
   integer base_h
   integer base_a
   integer base_b
   integer base_c
   integer base_d
   integer base_s
   varchar(100) icon
   varchar(100) icon2
   boolean is_restriction
}
class types {
   integer id
   varchar(10) name
}
class users {
   integer id
   varchar(50) name
   varchar(255) auth_id
   text profile
   varchar(100) icon
}

grown_pokemons  -->  abilities : ability-id
grown_pokemons  -->  goods : good-id
grown_pokemons  -->  moves : move1-id
grown_pokemons  -->  moves : move2-id
grown_pokemons  -->  moves : move3-id
grown_pokemons  -->  moves : move4-id
grown_pokemons  -->  natures : nature-id
grown_pokemons  -->  pokemons : pokemon-id
grown_pokemons  -->  users : user-id
moves  -->  move_selects : select-id
moves  -->  types : type-id
pokemon_ability_map  -->  abilities : ability-id
pokemon_ability_map  -->  pokemons : pokemon-id
pokemon_build_map  -->  grown_pokemons : pokemon-id
pokemon_build_map  -->  pokemon_builds : build-id
pokemon_builds  -->  users : user-id
pokemon_move_map  -->  game_versions : version-id
pokemon_move_map  -->  moves : move-id
pokemon_move_map  -->  pokemons : pokemon-id
pokemon_tag_map  -->  pokemon_tags : tag-id
pokemon_tag_map  -->  pokemons : pokemon-id
pokemon_type_map  -->  pokemons : pokemon-id
pokemon_type_map  -->  types : type-id

原則としてキー制約にnullableとついてないカラムはNOT NULL制約があります。

テーブル定義一覧

マスタ系

マスタ値(技、特性、道具、ポケモンは除く)

Pokemons

Moves

Ability, Goods

ユーザーデータ