Database Schema - lucianjones/Team-Tianwen GitHub Wiki
Users
| Column Name | Data type | Details |
|---|---|---|
| id | integer | not null, primary key |
| username | string | not null, unique |
| hashedPassword | string.binary | not null, unique |
| string | not null, indexed, unique | |
| created_at | datetime | not null |
| updated_at | datetime | not null |
Questions
| Column Name | Data type | Details |
|---|---|---|
| id | integer | not null, primary key |
| title | string | not null |
| description | string | not null |
| userId | integer | not null, foreign Key |
| created_at | datetime | not null |
| updated_at | datetime | not null |
Answers
| Column Name | Data type | Details |
|---|---|---|
| id | integer | not null, primary key |
| description | string | not null |
| userId | integer | not null, foreign Key |
| questionId | integer | not null, foreign Key |
| created_at | datetime | not null |
| updated_at | datetime | not null |
Votes
| Column Name | Data type | Details |
|---|---|---|
| id | integer | not null, primary key |
| answerId | integer | not null, foreign key |
| userId | integer | not null, foreign Key |
| created_at | datetime | not null |
| updated_at | datetime | not null |