This illustration shows the orders master table and the customers master table. The customers table has a customer_id primary key column and the orders table has a customer_id foreign key column. There is a many to one relationship between the orders and customers tables because one customer can have many orders but an order can have only one customer.