Grokking the System Design Interview, Volume II
Vote

0% completed

​

Flash Sale: Database Schema

Step 5: Database Schema

Six tables carry this design: Users, Products, Inventory, Reservation, Orders, and Payments. Two of them, Inventory and Reservation, do almost all the work of keeping the sale honest. After the tables, we cover indexing, partitioning, and the constraints that keep this schema correct during high-volume events.

Users Table

The Users table stores accounts and login details.

| Field Name | Data Type | Description |

.....

.....

.....

Like the course? Get enrolled and start learning!

Reading Progress

0%

Vote for new content