| id | company_name | ipo_date | raised_capital_amount | shares_offered |
|---|---|---|---|---|
| 1 | TechCorp | 2019-07-08 | 50000000.0 | 1000000 |
| 2 | HealthInc | 2019-06-30 | 15000000.0 | 500000 |
| id | company_name | secondary_offering_date | raised_capital_amount | shares_offered |
|---|---|---|---|---|
| 1 | Finance Ltd. | 2020-09-15 | 50000000.0 | 2000000 |
| 2 | Energy Corp | 2019-08-10 | 20000000.0 | 800000 |
| customer_id | first_name | last_name | phone_number | |
|---|---|---|---|---|
| 1 | John | Doe | john@gmail.com | +123456789 |
| 2 | Jane | Smith | jane@yahoo.com | +987654321 |
| account_id | customer_id | balance |
|---|---|---|
| (→ Customers.customer_id) | ||
| 1 | 1 | 10000.0 |
| 2 | 2 | 5000.0 |
| transaction_id | account_id | amount | transaction_type | transaction_date |
|---|---|---|---|---|
| (→ Accounts.account_id) | ||||
| 1 | 1 | 1000.0 | Deposit | 2024-03-13 18:43:34 |
| 2 | 2 | -500.0 | Withdrawal | 2024-03-13 18:43:34 |
| loan_id | customer_id | loan_amount | interest_rate | start_date | end_date |
|---|---|---|---|---|---|
| (→ Customers.customer_id) | |||||
| 1 | 1 | 100000.0 | 5.0 | 2024-03-13 18:43:34 | 2025-08-10 |
| 2 | 2 | 50000.0 | 4.0 | 2024-03-13 18:43:34 | 2024-08-10 |