Database Schema

trainers

column name	column type	constraints
id	integer	not null, primary key
username	varchar	not null, unique
password	string	not null
emailAddress	varchar	not null, unique
created_at	datetime	not null
updated_at	datetime	not null

pokemons

column name	column type	constraints
id	integer	not null, primary key
name	varchar	not null
image	varchar	not null
region	string	not null
type	string	not null

reviews

column name	column type	constraints
id	integer	not null, primary key
review	text	not null
rating	numeric
created_at	datetime	not null
updated_at	datetime	not null
trainerId	integer	not null
pokemonId	integer	not null

• trainerId references trainers table
• pokemonId references pokemons table

catchlists

column name	column type	constraints
id	integer	not null, primary key
catchstatus	varchar	not null
trainerId	integer	not null

• trainerId references trainers table

catchlistJoinPokemons

column name	column type	constraints
id	integer	not null, primary key
pokemonId	integer	not null
catchlistId	integer	not null

• pokemonId references pokemons table
• catchlistId references catchlists table