Banking Database Schema

erDiagram
  CUSTOMER ||--o{ ACCOUNT_HOLDER : holds
  ACCOUNT ||--|{ ACCOUNT_HOLDER : "held by"
  BRANCH ||--o{ ACCOUNT : manages
  ACCOUNT ||--o{ TRANSACTION : records
  ACCOUNT ||--o{ CARD : issues
  CUSTOMER ||--o{ BENEFICIARY : adds
  CUSTOMER ||--o{ LOAN : takes
  LOAN ||--|{ EMI_SCHEDULE : "repaid by"
  CUSTOMER {
    int id PK
    string cif_no
    string name
    string pan
  }
  ACCOUNT {
    int id PK
    string account_no
    string type
    decimal balance
    int branch_id FK
  }
  TRANSACTION {
    int id PK
    int account_id FK
    string type
    decimal amount
    datetime posted_at
  }
  LOAN {
    int id PK
    int customer_id FK
    decimal principal
    decimal rate
  }
  EMI_SCHEDULE {
    int id PK
    int loan_id FK
    date due_date
    decimal amount
  }