Database Schema - mustafaomousa/EncephaScape GitHub Wiki
Database Schema
User
| Column Name |
Data Type |
Details |
| id |
integer |
pk, not null |
| username |
varchar(30) |
unique, not null |
| email |
varchar(256) |
unique, not null |
| phone number |
big int |
unique, not null |
| hashedPassword |
binary int |
not null |
Category
| Column Name |
Data Type |
Details |
| id |
integer |
pk, not null |
| name |
varchar(20) |
unique, not null |
Stack
| Column Name |
Data Type |
Details |
| id |
integer |
pk, not null |
| name |
varchar(20) |
not null |
| categoryId |
integer |
fk, not null |
| userId |
integer |
fk, not null |
Card
| Column Name |
Data Type |
Details |
| id |
integer |
pk, not null |
| stackId |
integer |
fk, not null |
| term |
varchar(255) |
not null |
| response |
varchar(255) |
not null |