🏦 1. BANK_CUSTOMERS
Stores core customer details for banking and fintech systems.
BANK_CUSTOMERS
--------------
customer_id NUMBER(10) PRIMARY KEY
customer_name VARCHAR2(100)
date_of_birth DATE
pan_number VARCHAR2(10)
mobile_number VARCHAR2(15)
email_id VARCHAR2(100)
created_date DATE
status VARCHAR2(20)
💰 2. BANK_ACCOUNTS
Maintains account-level details including balances.
BANK_ACCOUNTS
-------------
account_id NUMBER(10) PRIMARY KEY
customer_id NUMBER(10)
account_type VARCHAR2(20)
account_balance NUMBER(15,2)
branch_code VARCHAR2(10)
opened_date DATE
account_status VARCHAR2(20)
🔄 3. TRANSACTIONS
Tracks all debit and credit transactions.
TRANSACTIONS
------------
transaction_id NUMBER(12) PRIMARY KEY
account_id NUMBER(10)
transaction_type VARCHAR2(10) -- DEBIT / CREDIT
transaction_amount NUMBER(15,2)
transaction_date DATE
remarks VARCHAR2(200)
💳 4. PAYMENTS
Used for fintech, UPI, wallet, and digital payment scenarios.
PAYMENTS
--------
payment_id NUMBER(12) PRIMARY KEY
customer_id NUMBER(10)
payment_mode VARCHAR2(20) -- UPI / CARD / WALLET
amount NUMBER(12,2)
payment_status VARCHAR2(20)
payment_date DATE
reference_number VARCHAR2(50)
📈 5. STOCK_PRICES
Stores real-time and historical stock price data.
STOCK_PRICES
------------
stock_id NUMBER(10) PRIMARY KEY
stock_symbol VARCHAR2(10)
price NUMBER(10,2)
price_date DATE
market_type VARCHAR2(20) -- NSE / BSE
📊 6. TRADES
Captures buy and sell transactions in share markets.
TRADES
------
trade_id NUMBER(12) PRIMARY KEY
customer_id NUMBER(10)
stock_symbol VARCHAR2(10)
trade_type VARCHAR2(10) -- BUY / SELL
quantity NUMBER(10)
trade_price NUMBER(10,2)
trade_date DATE
🧾 7. LOANS
Used for loan eligibility, EMI, and risk analysis.
LOANS
-----
loan_id NUMBER(10) PRIMARY KEY
customer_id NUMBER(10)
loan_amount NUMBER(15,2)
interest_rate NUMBER(5,2)
loan_tenure_years NUMBER(3)
loan_status VARCHAR2(20)
start_date DATE
🧑💼 8. EMPLOYEES
Supports salary processing and internal banking operations.
EMPLOYEES
---------
employee_id NUMBER(10) PRIMARY KEY
employee_name VARCHAR2(100)
designation VARCHAR2(50)
salary NUMBER(12,2)
department VARCHAR2(50)
joining_date DATE
📝 9. TRANSACTION_LOG
Used for auditing, logging, and exception handling practice.
TRANSACTION_LOG
---------------
log_id NUMBER(12) PRIMARY KEY
reference_id NUMBER(12)
log_message VARCHAR2(200)
log_date DATE
log_type VARCHAR2(20)