Very well done! Finally, we'll take a look at the
orders table contains information about orders such as the
customer_id, and the
employee_id of the worker responsible for that order. There are also timestamp columns (
shipped_date) and a lot of columns related to the shipment process. Finally, there is the
amount column, which shows the total amount paid for that order.
order_items table, in turn, stores information about what was actually ordered in a given order. Each row represents a single line item from an order. You can find the
product_id, and the
amount paid for the specific item.