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
Payment Gateway Database Schema Template | ERD Studio