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