Grokking the System Design Interview, Volume II
Vote

0% completed

​

Step 5: Database Schema

Seven tables carry this design: Users, Products, Inventory, InventoryUpdated, Reservation, Orders, and Payments. Two of them, Inventory and Reservation, do most of the work of keeping the sale correct. The tables live in the databases of the services that own them: Inventory and InventoryUpdated in the Inventory Service's database, Reservation and Orders in the Order Service's, and Payments in the Payment Service's.

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