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 |