Clients

client_idfirst_namelast_nameemailphone_numberaddress
1JohnDoejohn.doe@example.com+1234567890123 Main St
2JaneSmithjane.smith@example.com+0987654321456 Elm St

Accounts

account_idclient_idbalance
(→ Clients.client_id)
111000.0
222000.0

Transactions

transaction_idfrom_accountto_accountamount
(→ Accounts.account_id)(→ Accounts.account_id)
112-100.0
22150.0

StockMarketOfferings

offering_idtypedateprice
(→ RaisedCapitalAmounts.offering_id)
1IPO2022-01-0110.0
2IPO2022-01-0112.0
3Secondary Offering2022-01-0115.0
4Secondary Offering2022-01-0118.0

RaisedCapitalAmounts

offering_idamount
(→ StockMarketOfferings.offering_id)
150000000.0
260000000.0
350000000.0
440000000.0