This illustration shows the customers master table and the orders 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 one to many relationship between the customers and orders tables because one customer can have many orders but an order can have only one customer.