Back to Home
ERD Studio
Browse Templates/Payment Gateway

Payment Gateway

A robust payment gateway database schema for building payment processing platforms like Stripe or PayPal. Includes merchant onboarding and management, multi-method payment processing (cards, bank transfers, digital wallets), detailed transaction tracking with idempotency keys, refund workflow management, and webhook event logging for asynchronous notifications. Ideal for fintech companies, payment aggregators, or e-commerce payment infrastructure.

PostgreSQL10 tablesFinance
financepaymentsgatewaymerchantsrefundswebhooks
Created with ERD Studio

Tables in this template

merchantsMerchants
7 cols
merchant_settingsMerchant Settings
7 cols
payment_methodsPayment Methods
8 cols
transactionsTransactions
10 cols
refundsRefunds
6 cols
disputesDisputes
8 cols
webhooksWebhooks
6 cols
webhook_eventsWebhook Events
8 cols
settlementsSettlements
10 cols
api_keysAPI Keys
9 cols

Related Templates

View all templates →

Banking System

Core banking system with customers, accounts, transactions, transfers, cards, and loan management.

PostgreSQL10 tables
financebankingaccounts+3
Finance

Accounting System

Double-entry accounting system with chart of accounts, journal entries, journal lines, invoices, and invoice items.

PostgreSQL10 tables
financeaccountingdouble-entry+3
Finance

Investment Portfolio

Investment management system with investors, portfolios, assets, trades, and dividend tracking.

PostgreSQL10 tables
financeinvestingportfolio+3
Finance

Insurance Claims

Insurance claims management with policyholders, policies, claims, claim documents, and adjuster assignments.

PostgreSQL10 tables
financeinsuranceclaims+3
Finance
Payment Gateway Database Schema Template | ERD Studio