Very well done! Finally, we'll take a look at the
Orders table contains information about orders such as the
CustomerId, and the
EmployeeId of the worker responsible for that order. There are also timestamp columns (
ShippedDate) 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.
OrderItems 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
ProductId, and the
Amount paid for the specific item.