Create the orders Table

Introduction

We’ll continue the creation of our simple customer relationship management system. We already created the customers and products tables, and we’re now ready to create two more tables, orders and order_items.

Model details

The orders table holds the header of the order:

• It has a reference to the owning customer by the customer_id column. This is going to be a ...