Problem:
I'm creating a program that gets the price of a product on a website stores information on that product, the user adds this product to an alert list where when the price changes the user is sent a notification.
I'm currently designing a database to store this info.
I've got these tables: user, list, product
I'm trying to workout what fields to store in my list table, each list is unique and can hold multiple products within the 1 unique list, I'm trying to wrap my head around how I store multiple products with multiple unique ids within the one list so that when a list is queried it returns the products the user has in that list, I've been researching best practices on this but I'm missing something and hoping this can be explained to me for my situation
I've currently got the following for each table
user
ID
username
email
password
created_on
created_by
list
list_name
product_ids(there will be many of these within one list)
user_id
created_on
list_id
product
product_id
product_name
product_price
last_updated
created_on
stock_status
product_url