Database Schema

Database Schema

users

column name	data type	details
id	int	not null, primary key
username	varchar	not null, unique
email	varchar	not null, unique
hashedPassword	varchar	not null, binary string
imgURL	varchar
credits	int

categories

column name	data type	details
id	int	not null, primary key
name	varchar	not null

products

column name	data type	details
id	int	not null, primary key
quantity	int	not null
price	int	not null
name	varchar	not null
description	text
imgURL	varchar
userId	int	not null
categoryId	int	not null

reviews

column name	data type	details
id	int	not null, primary key
rating	int	not null
content	varchar	not null
userId	int	not null
productId	int	not null

orders

column name	data type	details
id	int	not null, primary key
userId	int	not null

order_product

column name	data type	details
id	int	not null, primary key
orderId	int	not null
productId	int	not null

favorites

column name	data type	details
id	int	not null, primary key
userId	int	not null
productId	int	not null

shopping_cart_items

column name	data type	details
id	int	not null, primary key
userId	int	not null
productId	int	not null
quantity	int	not null