Database Schema - jrchew15/word-play-puzzles GitHub Wiki

Users Table

Column	Data Types	Details
id	integer	primary key
email	string	not null
username	string	not null
hashed_password	string	not null
profile_picture	string	image url
theme	string	light or dark
created_at	date	not null

Wordgons Table

Column	Data Types	Details
id	integer	primary key
user_id	integer	foreign key
letters	string	length: 9
shape	string	enumerated
num_attempts	integer	not null
puzzle_day	date

WordgonSessions Table

Column	Data Types	Details
id	integer	primary key
puzzle_id	integer	foreign key
user_id	integer	foreign key
guesses	string
num_guesses	integer
completed	boolean
created_at	datetime
updated_at	datetime

Comments Table

Column	Data Types	Details
id	integer	primary key
puzzle_id	integer	foreign key
user_id	integer	foreign key
body	string	not null
reply_to	integer	foreign key
created_at	datetime
updated_at	datetime