Currency_Exchange_Service
id | Name | Year_of_establishment | Number_of_branches | Total_assets |
1 | CX1 | 2000 | 100 | 1000000.0 |
2 | CX2 | 2010 | 80 | 900000.0 |
Commodity_Trading_Firm
id | Name | Year_of_establishment | Number_of_employees | Annual_revenue |
1 | CT1 | 2000 | 300 | 7500000.0 |
2 | CT2 | 2010 | 200 | 6500000.0 |
Customer
id | First_Name | Last_Name | Date_of_birth | Email |
1 | John | Doe | 1980-01-01 | john.doe@example.com |
2 | Jane | Smith | 1985-02-15 | jane.smith@example.com |
Account
id | customer_id | account_type | balance |
| (→ Customer.id) | | |
1 | 1 | Checking | 500.0 |
2 | 2 | Savings | 1000.0 |
Loan
id | customer_id | loan_amount | interest_rate | start_date | end_date |
| (→ Customer.id) | | | | |
1 | 1 | 150000.0 | 5.0 | 2021-01-01 | 2026-01-01 |
2 | 2 | 200000.0 | 6.0 | 2021-02-01 | 2027-02-01 |
Investment
id | customer_id | investment_type | amount | date_purchased | current_value |
| (→ Customer.id) | | | | |
1 | 1 | Stocks | 20000.0 | 2020-03-01 | 21000.0 |
2 | 2 | Bonds | 5000.0 | 2019-04-01 | 5500.0 |