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