DDL：/db/ddl/ddl-*.sql
2022/08/12現在
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制約があります。