Linking Some Tables

I have three tables :

Product
---------
Product ID key
image
Description

Order Item
------------
Order ID key
Product ID fkey
Quantity


Saved Orders (a record of bought transactions)
---------------
SavedOrderID key
Name
Date
Product ID fkey
Quantity

The order item reduces its quantity when an order is made. If all of the item is bought than the order item record is deleted.

My question are:

1. Does the link and columns look okay for the three tables?
2. Should Saved Orders be...

Linking Some Tables

from Databases https://ift.tt/2yHyq5Y
via IFTTT