Database Schema - Justin-Stockton/PokeHunt GitHub Wiki
Users
| Column Name |
Data Type |
Details |
| id |
integer |
not null, primary key |
| userName |
string(20) |
not null, unique |
| email |
string(100) |
not null, unique |
| hashedPassword |
string(100) |
not null |
| createdAt |
timestamp |
not null |
| updatedAt |
timestamp |
not null |
Pokemon
| Column Name |
Data Type |
Details |
| id |
integer |
not null, primary key |
| userId |
integer |
not null |
| name |
string(100) |
not null |
| imgUrl |
string(255) |
|
| createdAt |
timestamp |
not null |
| updatedAt |
timestamp |
not null |
Reviews
| Column Name |
Data Type |
Details |
| id |
integer |
not null, primary key |
| userId |
integer |
not null |
| pokemonId |
integer |
not null |
| review |
text |
not null |
| createdAt |
timestamp |
not null |
| updatedAt |
timestamp |
not null |
Votes
| Column Name |
Data Type |
Details |
| id |
integer |
not null, primary key |
| userId |
integer |
not null |
| pokemonId |
integer |
not null |
| upVote |
boolean |
not null |
| createdAt |
timestamp |
not null |
| updatedAt |
timestamp |
not null |
Tags
| Column Name |
Data Type |
Details |
| id |
integer |
not null, primary key |
| pokemonId |
integer |
not null |
| tag |
string(20) |
not null |
| createdAt |
timestamp |
not null |
| updatedAt |
timestamp |
not null |