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 |