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 |