Organizations
org_id | organization |
1 | ABC Group |
2 | XYZ Company |
Customers
customer_id | first_name | last_name | date_of_birth | phone_number | email | org_id |
| | | | | | (→ Organizations.org_id) |
1 | John | Doe | 1980-01-01 | 555-1234 | john.doe@example.com | 1 |
2 | Jane | Smith | 1975-06-15 | 555-5678 | jane.smith@example.com | 2 |
Accounts
account_id | account_type | balance | interest_rate | customer_id |
| | | | (→ Customers.customer_id) |
1 | Checking | 1000.0 | 0.01 | 1 |
2 | Savings | 5000.0 | 0.02 | 1 |
Transactions
transaction_id | description | amount | transaction_date | account_id |
| | | | (→ Accounts.account_id) |
1 | Initial Deposit | 1000.0 | 2024-03-13 15:09:16 | 1 |
2 | Monthly Interest Earned | 10.0 | 2024-03-13 15:09:16 | 1 |
Services
service_id | financial_service | organization_id |
| | (→ Organizations.org_id) |
1 | Custodial Service | 1 |
2 | Custodial Service | 2 |
3 | Trust Administration | 1 |
4 | Trust Administration | 2 |