Grokking the System Design Interview, Volume II
Vote

0% completed

​

Step 5: Database Schema

Every table in this schema except one is keyed by merchant. That single choice lets one database transaction cover a charge, its ledger entry, and the merchant's balance, because all three live on the same shard. The diagram shows how the tables connect.

Merchants

One row per business account. The table is small, so it can stay unsharded or be replicated to every shard.

Field NameData TypeDescription

.....

.....

.....

Like the course? Get enrolled and start learning!

Reading Progress

0%

Vote for new content