Database Schema

Users

Users	data type	details
id	integer	PK NOT NULL
username	string(50)
fullname	string(100)
email	string(100)
hashed_password	string(100)
address	string(200)
city	string(100)
state	string(50)
zip	integer(5)

Donations

Donations	data type	details
id	integer	PK NOT NULL
userid	integer
projectid	integer
amount	integer
tier	integer

Projects

Projects	data type	details
id	integer	PK NOT NULL
userid	integer
categoryId	integer
regionId	integer
title	string(100)
description	string(2000)
goal	integer
amountRaised	integer
status	string
address	string(200)
city	string(100)
state	string(50)
zip	integer(5)

Regions

regions	data type	details
id	integer	PK NOT NULL
cityCode	integer
cityStateCode	integer

Categories

Categories	data type	details
id	integer	PK NOT NULL
name	string