| id | name | country_id |
|---|---|---|
| 1 | New York | 1 |
| 2 | London | 2 |
| 3 | Tokyo | 3 |
| 4 | Paris | 4 |
| 5 | Mumbai | 5 |
| id | name |
|---|---|
| 1 | USA |
| 2 | UK |
| 3 | Japan |
| 4 | France |
| 5 | India |
| id | bank_name | city_id | country_id |
|---|---|---|---|
| (→ City.id) | (→ Country.id) | ||
| 1 | Bank A | 1 | 1 |
| 2 | Bank B | 2 | 2 |
| 3 | Bank C | 3 | 3 |
| 4 | Bank D | 4 | 4 |
| 5 | Bank E | 5 | 5 |
| account_number | balance | owner_id |
|---|---|---|
| (→ Banks.id) | ||
| 1 | 1000.0 | 1 |
| 2 | 800.0 | 2 |
| 3 | 1200.0 | 3 |
| 4 | 900.0 | 4 |
| 5 | 700.0 | 5 |
| transaction_id | date | amount | debit_account_id | credit_account_id |
|---|---|---|---|---|
| (→ Accounts.account_number) | (→ Accounts.account_number) | |||
| 1 | 2024-02-19 14:18:41 | 100.0 | 1 | 2 |
| 2 | 2024-02-19 14:18:41 | 200.0 | 3 | 4 |
| 3 | 2024-02-19 14:18:41 | 300.0 | 5 | 1 |
| 4 | 2024-02-19 14:18:41 | 400.0 | 2 | 3 |
| 5 | 2024-02-19 14:18:41 | 500.0 | 4 | 5 |
| customer_id | first_name | last_name | birth_date | address | phone | |
|---|---|---|---|---|---|---|
| (→ Accounts.owner_id) | ||||||
| 1 | John | Doe | 1980-01-01 | 123 Main St | 555-1234 | john.doe@example.com |
| 2 | Jane | Smith | 1985-06-01 | 456 Elm St | 555-5678 | jane.smith@example.com |
| 3 | Alice | Williams | 1990-12-01 | 789 Oak St | 555-9012 | alice.williams@example.com |
| 4 | Bob | Johnson | 1988-03-01 | 135 Pine St | 555-1314 | bob.johnson@example.com |
| 5 | Carol | Brown | 1992-09-01 | 246 Maple St | 555-1415 | carol.brown@example.com |