POKEDEXDB

This database houses the data for the NationalDex Pokémon, their characteristics, and keeps track of a personal Pokédex.

Lookups

tlkpAbility, tlkpCategory, tlkpType

Name	Data Type	Is Primary Key
Id	int	Yes
Name	varchar(MAX)	No

tlkpPokeball

Name	Data Type	Is Primary Key
Id	int	Yes
Name	varchar(MAX)	No
ImageURL	varchar(MAX)	No

tlkpNationalDex

Name	Data Type	Is Primary Key	Constraints
Id	int	Yes	None
Name	varchar(MAX)	No	None
Japanese Name	varchar(MAX), nullable	No	None
Description	varchar(MAX), nullable	No	None
CategoryId	int, nullable	No	Foreign Key on tlkpCategory.Id
TypeOneId	int, nullable	No	Foreign Key on tlkpType.Id
TypeTwoId	int, nullable	No	Foreign Key on tlkpType.Id
AbilityId	int, nullable	No	Foreign Key on tlkpAbility.Id
HiddenAbilityId	int, nullable	No	Foreign Key on tlkpAbility.Id
ImageURL	varchar(MAX), nullable	No	None
HeightInInches	int	No	None
WeightInPounds	int	No	None

Tables

tblMyPokedex

Name	Data Type	Is Primary Key	Constraints
Id	uniqueidentifier	Yes	None
PokemonId	int	No	Foreign Key on tlkpNationalDex.Id
Nickname	varchar(MAX), nullable	No	None
Level	int	No	None
Sex	bit, nullable	No	None
Date	Date, nullable	No	None
Location	varchar(MAX), nullable	No	None
PokeballId	int	No	Foreign Key on tlkpPokeball.Id

Scripts

Populate*.sql files are used to seed the database. Insert commands are used to insert the data into the correct tables/lookups. Post deployment script is run on publish, which calls the Populate* files