This schema contains two tables, order and order_item. The relationship between them is as follows:

The order table holds the generic details of each order, such as orderId, userId, order date, total amount, and shipping address. The order_item table saves individual item details.