https://dbdiagram.io/d/605f8aafecb54e10c33d9076

Users

Column Name	Data Type	Details
id	integer	not null, primary key
username	varchar	not null, unique
email	email	not null, unique
password	varchar	not null

Products

Column Name	Data Type	Details
id	integer	not null, primary key
name	varchar	not null, unique
Category	varchar	not null
description	string	not null
price	integer	not null

Reviews

Column Name	Data Type	Details
id	integer	not null, primary key
review	STRING	not null
userId	int	not null
productId	int	not null

    * userId references user table
    * productId references products table

Cart

Column Name	Data Type	Details
id	integer	not null, primary key
userId	integer	not null, unique
productId	integer	not null, unique

    * userId references user table
    * productId references products table