Database Schema

---

Users

---

Column Name	Data Type	details
id	integer	not null, primary key
username	string	not null
email	string	not null, unique
hashedPassword	string	not null
createdAt	datetime	not null
updatedAt	datetime	not null

Questions

---

Column Name	Data Type	Details
id	integer	not null, primary key
content	string	not null
userId	integer	not null, foreign key
createdAt	datetime	not null
updatedAt	datetime	not null

Answers

---

Column Name	Data Type	Details
id	integer	not null, primary key
content	string	not null
userId	integer	not null, foreign key
questionId	integer	not null, foreign key
createdAt	datetime	not null
updatedAt	datetime	not null

QuestionVotes

---

Column Name	Data Type	Details
id	integer	not null, primary key
upVote	boolean	not null
userId	integer	not null, foreign key
questionId	integer	not null, foreign key
createdAt	datetime	not null
updatedAt	datetime	not null

AnswerVotes

---

Column Name	Data Type	Details
id	integer	not null, primary key
upVote	boolean	not null
userId	integer	not null, foreign key
answerId	integer	not null, foreign key
createdAt	datetime	not null
updatedAt	datetime	not null