fintech-transfer-service

Tables (3)

accounts (Account Table)

  • Account ID (account_id) — BIGINT — Primary key — NOT NULL
  • User ID (user_id) — BIGINT — Foreign key → users.User ID — NOT NULL
  • Account Number (account_number) — VARCHAR
  • Balance (balance) — DECIMAL
  • Created At (created_at) — TIMESTAMP

transfers (Transfer Table)

  • Transfer ID (transfer_id) — BIGINT — Primary key — NOT NULL
  • Sender Account Number (sender_account_number) — VARCHAR
  • Receiver Account Number (receiver_account_number) — VARCHAR
  • Amount (amount) — DECIMAL
  • Status (status) — VARCHAR
  • Created at (created_at) — TIMESTAMP

users (User Table)

  • User ID (user_id) — BIGINT — Primary key — NOT NULL
  • Email (email) — VARCHAR
  • Password (password) — VARCHAR
  • First Name (first_name) — VARCHAR
  • Last Name (last_name) — VARCHAR
  • Created At (created_at) — TIMESTAMP