Data model for the e-Commerce application
The following tables are designed to support the e-Commerce application demonstrated in this workshop.
- CUSTOMER table contains customer's identification number, name, e-mail, and birth date.
- PRODUCT table contains product description, price per unit, and product category.
- CATEGORY table contains the hierarchical relationship between different categories.
- ORDERS table contains information about the orders with references to the associated customers.
- ORDER_DETAILS table contains detailed information on individual items in every order.
- SHOPPING_CART is a Created Global Temporary Table (CGTT) used to store the shopping cart details.