Database Schema - ggard214/Computables_App GitHub Wiki

Users Table

Column Name	Data Type	Details
ID (pk)	integer	not null, primary key
username	Varchar (30)	not null, unique
email	Varchar(256)	not null, unique
hashedPassword	bytea	not null
created at	datetime	not null
updated at	datetime	not null

Projects Table

Column Name	Data Type	Details
ID (pk)	integer	not null, primary key
title	string	not null
summary	textarea	not null
steps	textarea	not null
userID	integer	Foreign Key to Users table
created at	datetime	not null
updated at	datetime	not null

Comments Table

Column Name	Data Type	Details
ID (pk)	integer	not null, primary key
comment	textarea	not null
userId	integer	Foreign Key to Users Table
projId	integer	Foreign Key to Projects Table
created at	datetime	not null
updated at	datetime	not null

PicVids Table

Column Name	Data Type	Details
ID (pk)	integer	not null, primary key
picvidURL	string	not null
projId	integer	Foreign Key to Projects Table
created at	datetime	not null
updated at	datetime	not null

Topics Table

Column Name	Data Type	Details
ID (pk)	integer	not null, primary key
topic	string	not null
created at	datetime	not null
updated at	datetime	not null

TopProjJoins Table

Column Name	Data Type	Details
ID (pk)	integer	not null, primary key
topId	integer	Foreign Key to category table
projId	integer	Foreign Key to Project Table
created at	datetime	not null
updated at	datetime	not null