transaction_id | transaction_type | bank_account | amount | date |
---|---|---|---|---|
1 | Payment | 1234567 | 1000.0 | 2022-09-01 |
2 | Payment | 9876543 | 1500.0 | 2022-09-01 |
3 | Remittance Transfer | 1234567 | 2000.0 | 2022-09-01 |
4 | Remittance Transfer | 9876543 | 3000.0 | 2022-09-01 |
5 | Deposit | 1234567 | 2500.0 | 2022-09-01 |
6 | Withdrawal | 9876543 | 500.0 | 2022-09-01 |
customer_id | first_name | last_name | phone_number | |
---|---|---|---|---|
1 | John | Doe | john.doe@example.com | +1234567890 |
2 | Jane | Smith | jane.smith@example.com | +0987654321 |
3 | Alice | Brown | alice.brown@example.com | +1357924680 |
4 | Bob | White | bob.white@example.com | +2468013579 |
5 | Tom | Black | tom.black@example.com | +3579246801 |
account_id | bank_account | balance | interest_rate |
---|---|---|---|
1 | 1234567 | 5000.0 | 0.05 |
2 | 9876543 | 10000.0 | 0.04 |
3 | 1111111 | 15000.0 | 0.03 |
4 | 2222222 | 20000.0 | 0.02 |
5 | 3333333 | 25000.0 | 0.01 |
employee_id | first_name | last_name | hire_date | |
---|---|---|---|---|
1 | Mike | Adams | mike.adams@example.com | 2022-01-01 |
2 | Lisa | Wilson | lisa.wilson@example.com | 2021-08-15 |
3 | David | Jackson | david.jackson@example.com | 2022-05-20 |
4 | Emma | Taylor | emma.taylor@example.com | 2021-12-01 |
5 | Alex | Green | alex.green@example.com | 2022-03-15 |
loan_id | customer_id | loan_amount | interest_rate | start_date | end_date |
---|---|---|---|---|---|
(→ Customer.customer_id) | |||||
1 | 1 | $100000 | 0.05 | 2022-01-01 | 2026-01-01 |
2 | 2 | $150000 | 0.04 | 2021-01-01 | 2025-01-01 |
3 | 3 | $200000 | 0.03 | 2022-01-01 | 2026-01-01 |
4 | 4 | $250000 | 0.02 | 2021-01-01 | 2025-01-01 |
5 | 5 | $300000 | 0.01 | 2022-01-01 | 2026-01-01 |
savings_id | account_id | balance | annual_interst_rate | created_at |
---|---|---|---|---|
(→ Account.account_id) | ||||
1 | 1 | 5000.0 | 0.05 | 2022-01-01 |
2 | 2 | 10000.0 | 0.04 | 2021-01-01 |
3 | 3 | 15000.0 | 0.03 | 2022-01-01 |
4 | 4 | 20000.0 | 0.02 | 2021-01-01 |
5 | 5 | 25000.0 | 0.01 | 2022-01-01 |