Databases

Crowdfunding Campaigns & Escrow Pledges Schema

ER Diagrams · made in Skemio

ER diagram detailing crowdfunding campaigns, limited reward tiers, backer pledges, and escrow payment authorizations.
ER diagram detailing crowdfunding campaigns, limited reward tiers, backer pledges, and escrow payment authorizations.

What it shows

  • Enforce reward tier quantity caps using atomic stock allocations.
  • Segregate backer pledges from payment escrow authorizations.
  • Bind campaigns to explicit goal deadlines to govern all-or-nothing payouts.

The takeaway

Separate pledge intents from escrow authorizations to ensure safe rollbacks on failed campaigns.

More er diagrams