Databases

Freelance Marketplace Escrow & Milestones

ER Diagrams · made in Skemio

ER diagram featuring contracts, milestones, escrow deposits, and disputes demonstrating stateful milestone payment processing.
ER diagram featuring contracts, milestones, escrow deposits, and disputes demonstrating stateful milestone payment processing.

What it shows

  • Milestones decouple overall contract value into distinct fundable steps.
  • Escrow balances must be locked before work starts and released on sign-off.
  • Disputes freeze disbursement until explicit platform arbitration verdicts.

The takeaway

Isolate escrow contracts into funded milestone states to guarantee payouts without exposing platform liability.

More er diagrams