Schema

Users

column name	data type	details
id	int	not null, primary key
username	string	not null, unique
first_name	string	not null, unique
last_name	string	not null, unique
email	string	not null, unique
hashed_password	string	not null
created_at	datetime	not null
updated_at	datetime	not null

Problems

column name	data type	details
id	int	not null, primary key
category	string	not null, unique
difficulty	string	not null, unique
title	string	not null, unique
description	string	not null, unique
language	string	not null, unique
solution	string	not null, unique
created_at	datetime	not null
updated_at	datetime	not null

Reviews

column name	data type	details
id	int	not null, primary key
review	boolean	not null
users_id	int	not null
problems_id	int	not null
created_at	datetime	not null
updated_at	datetime	not null

• users_id references the User table
• problems_id references the Problems table

Solved

column name	data type	details
id	int	not null, primary key
solved_problem	boolean	not null
users_id	int	not null
problems_id	int	not null
created_at	datetime	not null
updated_at	datetime	not null

• users_id references the User table
• problems_id references the Problems table