skirill430 / Quick-Shop

CEN3031 Project
http://quickshop.hopto.org
0 stars 0 forks source link

Routes for adding/removing products from user #42

Closed danielwildsmith closed 1 year ago

danielwildsmith commented 1 year ago

Wondering how to store the product info within the database.

Maybe make a database that contains product id with all its attributes?

But then there is the issue of storing multiple products to a user. Containing a list of product ids within a column might get clunky.

danielwildsmith commented 1 year ago

A possible solution:

Database that stores username and password.

Secondary database that stores the products saved, with columns representing the product data as well as what user (by username) saved it.