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)