Tracks transaction IDs and shipping statuses. III. Detailed Database Schema

An entry is created in Orders , and details are moved to Order_Items .

💡 A successful database design separates "current state" (Inventory) from "historical record" (Order Items) to ensure financial accuracy. If you'd like to dive deeper, let me know: Do you need the SQL Create Table scripts?

I can provide the or ER Diagrams to help you finish the project.

OrderID , UserID (FK), OrderDate , TotalAmount , Status (Pending/Shipped/Delivered).

Stores credentials, roles (Admin/Customer), and profiles.

Records finalized transactions and historical pricing.

Use database transactions to ensure that stock is decremented only if the payment succeeds.