walnet

Tables (7)

account (Untitled2)

  • account_id (Key2) — Long — Primary key — NOT NULL
  • member_id (Key) — Long — Foreign key → member.member_id — NOT NULL
  • account_number (Field2) — String
  • bank_name (Field) — varchar

exchange (Untitled7)

  • transaction_id (Key) — Foreign key → transaction.transaction_id — NOT NULL
  • counter_currency (Field)
  • exchange_rate (Field2) — String

member (Untitled)

  • member_id (Key) — Long — Primary key — NOT NULL
  • member_name (Field) — String
  • login_id (Field2) — String
  • password (Field3) — String

payment (Untitled5)

  • transaction_id (Key) — Foreign key → transaction.transaction_id — NOT NULL
  • merchant_name (Field) — String

transaction (Untitled4)

  • transaction_id (Key) — Primary key — NOT NULL
  • wallet_id (Key2) — Foreign key → wallet.wallet_id — NOT NULL
  • transaction_currency (Field2)
  • amount (Field3) — BigDecimal
  • transaction_status (Field) — Enum
  • transaction_date (Field4)

transfer (Untitled6)

  • transaction_id (Key) — Foreign key → transaction.transaction_id — NOT NULL
  • account_number (Field)

wallet (Untitled3)

  • wallet_id (Key) — Long — Primary key — NOT NULL
  • member_id (Key2) — Long — Foreign key → member.member_id — NOT NULL
  • currency (Field) — Enum
  • balance (Field2) — decimal(18,6)