Banks
id | name | headquarter |
1 | Bank A | New York |
2 | Bank B | London |
3 | Bank C | Tokyo |
4 | Bank D | Paris |
5 | Bank E | Dubai |
Services
id | serviceName |
1 | Savings_Account |
2 | Current_Account |
3 | Loan |
4 | Credit_Card |
5 | Mortgage |
Customers
id | firstName | lastName | dateOfBirth |
1 | John | Smith | 1987-03-25 |
2 | Jane | Doe | 1992-06-10 |
3 | Peter | Black | 1980-10-15 |
4 | Emily | White | 1995-02-20 |
5 | David | Green | 1977-08-25 |
Accounts
id | accountNumber | balance | customerId |
| | | (→ Customers.id) |
1 | 123456789 | 10000.0 | 1 |
2 | 987654321 | 5000.0 | 2 |
3 | 543210987 | 7000.0 | 3 |
4 | 654321098 | 20000.0 | 4 |
5 | 876543210 | 8000.0 | 5 |
Transactions
id | transactionDate | amount | description | accountId |
| | | | (→ Accounts.id) |
1 | 2022-01-01 10:00:00 | 500.0 | Payment | 1 |
2 | 2022-01-02 15:30:00 | -300.0 | Withdrawal | 2 |
3 | 2022-01-03 09:15:00 | 700.0 | Deposit | 3 |
4 | 2022-01-04 12:45:00 | -400.0 | Transfer | 4 |
5 | 2022-01-05 17:00:00 | 900.0 | Online Purchase | 5 |
Banks_Services
bankId | serviceId |
(→ Banks.id) | (→ Services.id) |
1 | 1 |
1 | 2 |
2 | 1 |
2 | 2 |
3 | 3 |
3 | 4 |
3 | 1 |
4 | 1 |
5 | 1 |