Database Schema - Twprcntmlk/CapStoneProject GitHub Wiki
Users
| Column Name |
Data Type |
Details |
| id |
Integer |
not null, primary key |
| f_name |
String |
not null |
| l_name |
String |
not null |
| username |
String |
not null |
| email |
String |
not null, unique |
| hashed_password |
String |
not null |
| profile_image |
String |
not null |
| coin_balance |
Integer |
not null |
Decks
| Column Name |
Data Type |
Details |
| id |
Integer |
not null, primary key |
| user_id |
Integer |
not null, foreign key |
| deck |
Text |
not null |
Comments
| Column Name |
Data Type |
Details |
| id |
Integer |
not null, primary key |
| user_id |
Integer |
not null, foreign key |
| card_id |
Integer |
not null, foreign key |
| comments |
String |
not null |
| created_at |
Datetime |
not null, unique |
| updated_at |
Datetime |
not null |
Collections
| Column Name |
Data Type |
Details |
| user_id |
Integer |
not null, foreign key |
| card_id |
Integer |
not null, foreign key |
Cards
| Column Name |
Data Type |
Details |
| id |
Integer |
not null, primary key |
| api_id |
String |
not null |
| api_name |
String |
not null |
| api_set_name |
String |
not null |
| api_set_code |
String |
not null, unique |
| api_set_rarity |
String |
not null |
| api_set_price |
String |
not null |