Look into the thought process of deciding the columns for the orders and order items table.

Orders table schema

Deciding on the columns of any new table requires some basic understanding of how the module will look and what functionality we will offer. In this lesson, learn how to keep it simple and add necessary columns to perform business operations.

All we need to store is the restaurant, the table for which the order is placed, and the total amount. We will also store the date and time of the order completion. This allows us to quickly prepare the report of average order duration.

Get hands-on with 1200+ tech skills courses.