## Clients

client_id | first_name | last_name | email | phone_number | address
--- | --- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | +1234567890 | 123 Main St
2 | Jane | Smith | jane.smith@example.com | +0987654321 | 456 Elm St

## Accounts

account_id | client_id | balance
--- | --- | ---
| (→ Clients.client_id) |
1 | 1 | 1000.0
2 | 2 | 2000.0

## Transactions

transaction_id | from_account | to_account | amount
--- | --- | --- | ---
| (→ Accounts.account_id) | (→ Accounts.account_id) |
1 | 1 | 2 | -100.0
2 | 2 | 1 | 50.0

## StockMarketOfferings

offering_id | type | date | price
--- | --- | --- | ---
(→ RaisedCapitalAmounts.offering_id) |  |  |
1 | IPO | 2022-01-01 | 10.0
2 | IPO | 2022-01-01 | 12.0
3 | Secondary Offering | 2022-01-01 | 15.0
4 | Secondary Offering | 2022-01-01 | 18.0

## RaisedCapitalAmounts

offering_id | amount
--- | ---
(→ StockMarketOfferings.offering_id) |
1 | 50000000.0
2 | 60000000.0
3 | 50000000.0
4 | 40000000.0