Payment Gateway

Overview

Payment gateway schema like Stripe or PayPal. Handles payment authorization, capture, refunds, disputes, recurring billing, and webhook notifications.

Key Design Decisions

• Auth/Capture Flow: Two-phase payment processing
• Dispute Management: Chargeback tracking and evidence submission
• Webhook System: Event notifications for payment status changes
• Fraud Detection: Rule-based fraud scoring

Tables

12 tables covering payment methods, transactions, authorizations, captures, refunds, disputes, webhooks, and fraud scores. Production-grade payment processing foundation.