Currency_Exchange_Service

idNameYear_of_establishmentNumber_of_branchesTotal_assets
1CX120001001000000.0
2CX2201080900000.0

Commodity_Trading_Firm

idNameYear_of_establishmentNumber_of_employeesAnnual_revenue
1CT120003007500000.0
2CT220102006500000.0

Customer

idFirst_NameLast_NameDate_of_birthEmail
1JohnDoe1980-01-01john.doe@example.com
2JaneSmith1985-02-15jane.smith@example.com

Account

idcustomer_idaccount_typebalance
(→ Customer.id)
11Checking500.0
22Savings1000.0

Loan

idcustomer_idloan_amountinterest_ratestart_dateend_date
(→ Customer.id)
11150000.05.02021-01-012026-01-01
22200000.06.02021-02-012027-02-01

Investment

idcustomer_idinvestment_typeamountdate_purchasedcurrent_value
(→ Customer.id)
11Stocks20000.02020-03-0121000.0
22Bonds5000.02019-04-015500.0