Database Schema

users

column name	data type	details
id	integer	not null, primary key
username	string	not null, unique
hashedPassword	string	not null
email	string	not null, unique
createdAt	datetime	not null
updatedAt	datetime	not null

projects

column name	data type	details
id	integer	not null, primary key
name	string	not null
content	text	not null
userId	integer	not null, foreign Key
dueDate	date	not null
createdAt	datetime	not null
updatedAt	datetime	not null

• userId references users table

tasks

column name	data type	details
id	integer	not null, primary key
name	string	not null
content	text	not null
userId	integer	not null, foreign key
projectId	integer	not null, foreign key
dueDate	date	not null
language	string
createdAt	datetime	not null
updatedAt	datetime	not null

• userId references users table
• projectId references projects table

notes

column name	data type	details
id	integer	not null, primary key
content	text	not null
taskId	integer	not null
createdAt	datetime	not null
updatedAt	datetime	not null

• taskId references tasks table