Payphone

Tables (3)

Accounts

  • account_id — bigint — Primary key — NOT NULL
  • account_number — varchar(20)
  • user_id — bigint — Foreign key → Users.user_id — NOT NULL
  • balance — bigint
  • created_at — datetime

Transactions

  • transaction_id — varchar(500) — Primary key — NOT NULL
  • sender_account_id — bigint — Foreign key → Accounts.account_id — NOT NULL
  • receiver_account_id — bigint — Foreign key → Accounts.account_id — NOT NULL
  • amount — bigint
  • transaction_time — datetime

Users

  • user_id — bigint — Primary key — NOT NULL
  • username — varchar(50)
  • password — varchar(255)
  • email — varchar(100)
  • role — varchar(20)
  • created_at — datetime