We will definitely have a Customers table. We will store customer information in that table and use the primary key of this table as a reference in other tables, such as Orders and Cart.
The Customers table can be designed as follows. You can find the database script, named FlixOneStore.sql, with this book:
CRUD operations will be performed on these tables from the API. Let's start by doing some operations on this table from the API. More precisely, we are talking about the customer registration and login process.