Problem
Paradox Shop's order API already serves 800 RPS correctly. Its first-draft order schema contains the required tables but lacks enforceable relationships and integrity constraints, and the order-history lookup by customer is still a full scan against 40 million orders. Complete the schema text, and index the field that lookup depends on.
Required components
Click to add a component to the canvas.
Additional components
Browse by category. Click or drag a component onto the canvas.