The "Orders" table keeps a detailed record of each pizza order placed. It includes information about the customer, the employees who took and delivered the order, the delivery status, and details about the vehicle used for delivery. Key timestamps such as when the order was taken and delivered are also recorded, along with the total price and any other relevant order details.
The "Customers" table contains vital information about the clients, including their name, payment method, address, phone number, and email. It also tracks the date of their first order and any other relevant details, helping in maintaining a strong relationship with the customers by understanding their preferences and order history.
The "Pizza Ordered" table provides specific details about each pizza in an order. It includes the status, an image of the pizza, the topping code, base price, topping price, quantity, and total price of the pizza. This table links to the order it belongs to, as well as to the specific base and toppings used, facilitating accurate tracking of ingredients and pricing.
The "Employees" table holds information about the staff involved in the pizza delivery process. This includes their names, phone numbers, addresses, and other relevant details. This ensures efficient assignment of tasks and tracking of employee performance.
The "Toppings" table lists all available pizza toppings along with their prices, codes, and descriptions. This table ensures that every topping is properly accounted for and priced, contributing to accurate billing and inventory management.
The "Bases" table includes information about the different pizza bases available, including their codes, prices, and descriptions. This helps in offering a variety of options to customers and managing the inventory of pizza bases.
The "Vehicles" table maintains records of all delivery vehicles, including their license numbers, types, and other relevant details. This ensures proper management and maintenance of the delivery fleet, which is crucial for timely and efficient pizza deliveries.
Any support materials, such as spreadsheets and real-life work samples would be very helpful as they would help us better understand your business process.