ex

Tables (3)

accounts

  • account_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • account_number — VARCHAR(225)
  • balance — BIGINT

transactions

  • transaction_id — BIGINT — Primary key — NOT NULL
  • account_id — BIGINT — Foreign key → accounts.account_id — NOT NULL
  • type — VARCHAR(225)
  • amount — BIGINT
  • date — DATETIME
  • target_account — VARCHAR(225)
  • balance_after — BIGINT

users

  • user_id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(225)
  • password — VARCHAR(225)
  • name — VARCHAR(225)