Database schemas
E-commerce orders
Orders, line items and the price that must not change after checkout.
What this board gets wrong on purpose
The tension
inventory is a single quantity_on_hand with no reservation, so two concurrent checkouts both pass the stock check and oversell the last unit
The rest of this board
Available on Tier Slate
This page publishes the question. The answer — an 8-step narrated walkthrough and a 10-table schema — is the board itself, and it opens in Tierslate.
- 8walkthrough steps
- 10tables64 columns
More boards
Entity boards that Generate SQL turns into real DDL.