Database Schema

Users

column name	data type	details
id	integer	not null, primary key
username	varchar	not null, unique
created_at	timestamp	not null
hashed_password	varchar	not null

Questions

column name	data type	details
id	integer	not null, primary key
name	varchar	not null
post_typeId	integer	foreign key
userId	integer	not null, foreign key
content	text	not null

Post_types

column name	data type	details
id	integer	not null, primary key
name	varchar	not null

Answers

column name	data type	details
id	integer	not null, primary key
content	text	not null
userId	integer	not null, foreign key
questionId	integer	not null, foreign key

Comments

column name	data type	details
id	integer	not null, primary key
content	text	not null
userId	integer	not null, foreign key
answerId	integer	not null, foreign key

Likes

column name	data type	details
id	integer	not null, primary key
userId	integer	not null, foreign key
answerId	integer	foreign key
commentId	integer	foreign key
questionId	integer	foreign key