Database Schema

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
professionalUser	boolean	not null
created_at	datetime	not null
updated-at	datetime	not null

questions

column name	data type	details
id	integer	not null, primary key
question	string	not null
voteCount	integer	not null
userId	integer	not null, foreign key
created_at	datetime	not null
updated-at	datetime	not null

• userId references users table

answers

column name	data type	details
id	integer	not null, primary key
answer	string	not null
voteCount	integer	not null
userId	integer	not null, foreign key
questionId	integer	not null, foreign key
created_at	datetime	not null
updated-at	datetime	not null

• userId references users table
• questionId references questions table

commments

column name	data type	details
id	integer	not null, primary key
comment	string	not null
userId	integer	not null, indexed, foreign key
answerId	integer	indexed, foreign key

• userId references users table
• answerId references answers table