Core Banking System

Overview

Core banking system schema for retail banks. Manages customer accounts, transaction processing, loans, credit/debit cards, inter-account transfers, and multi-currency operations.

Key Design Decisions

• Account Types: Checking, savings, credit, loan accounts
• Transaction Processing: Double-entry with proper audit trails
• Loan Management: Origination, amortization, and payment tracking
• Card Systems: Card issuance and transaction authorization

Tables

15 tables covering customers, accounts, transactions, loans, cards, transfers, and fraud detection. Designed with financial accuracy and regulatory compliance in mind.