Database Schema - jrchew15/nah-sana GitHub Wiki

Users Table

Column	Data Types	Details
id	integer	primary key
first_name	string	not null
last_name	string	not null
role	string
email	string	not null
hashed_password	string	not null
image	string
pronouns	string
department	string

Project Table

Column	Data Types	Details
id	integer	primary key
workspace_id	integer	foreign key
owner_id	integer	foreign key
name	string	not null
status	string
due_date	date
description	string
icon	string

• workspace_id references workspaces table
• owner_id references users table

Task Table

Column	Data Types	Details
id	integer	primary key
project_id	integer	foreign key
user_id	integer	foreign key
name	string	not null
due_date	date
description	string
complete	boolean

• project_id references projects table
• user_id references users table

Workspace Table

Column	Data Types	Details
id	integer	primary key
name	string	not null

User Project Table

Column	Data Types	Details
id	integer	primary key
user_id	integer	foreign key
project_id	integer	foreign key

• user_id references user table
• project_id references project table

User Workspaces Table

Column	Data Types	Details
id	integer	primary key
workspace_id	integer	foreign key
user_id integer	integer	foreign key

• workspace_id references workspace table
• user_id references user table