IPOs

idcompany_nameipo_dateraised_capital_amountshares_offered
1TechCorp2019-07-0850000000.01000000
2HealthInc2019-06-3015000000.0500000

Secondary_Offerings

idcompany_namesecondary_offering_dateraised_capital_amountshares_offered
1Finance Ltd.2020-09-1550000000.02000000
2Energy Corp2019-08-1020000000.0800000

Customers

customer_idfirst_namelast_nameemailphone_number
1JohnDoejohn@gmail.com+123456789
2JaneSmithjane@yahoo.com+987654321

Accounts

account_idcustomer_idbalance
(→ Customers.customer_id)
1110000.0
225000.0

Transactions

transaction_idaccount_idamounttransaction_typetransaction_date
(→ Accounts.account_id)
111000.0Deposit2024-03-13 18:43:34
22-500.0Withdrawal2024-03-13 18:43:34

Loans

loan_idcustomer_idloan_amountinterest_ratestart_dateend_date
(→ Customers.customer_id)
11100000.05.02024-03-13 18:43:342025-08-10
2250000.04.02024-03-13 18:43:342024-08-10