customer_id | first_name | last_name | phone_number | |
---|---|---|---|---|
1 | John | Doe | john.doe@example.com | +123-456-7890 |
2 | Jane | Smith | jane.smith@example.com | +098-765-4321 |
3 | Michael | Brown | michael.brown@example.com | +456-789-0123 |
4 | Alice | White | alice.white@example.com | +135-790-2468 |
5 | David | Black | david.black@example.com | +246-890-1357 |
account_id | customer_id | account_type | balance |
---|---|---|---|
(→ Customers.customer_id) | |||
1 | None | Checking | 1000.0 |
2 | None | Savings | 5000.0 |
3 | None | Credit Card | 2000.0 |
4 | None | Loan | -1500.0 |
5 | None | Mortgage | -20000.0 |
app_id | app_version | release_date | platform |
---|---|---|---|
1 | v1.0 | 2021-01-01 | Android |
2 | v1.1 | 2021-05-01 | iOS |
3 | v1.2 | 2021-07-01 | Android |
4 | v1.3 | 2021-11-01 | iOS |
5 | v1.4 | 2022-01-01 | Android |
feature_id | feature_value |
---|---|
1 | Mobile Deposit |
2 | Bill Pay |
3 | Person to Person Payment |
4 | Fund Transfer between accounts |
5 | Account Alerts |
mobile_app_feature_id | mobile_banking_app_id | feature_id |
---|---|---|
(→ Mobile_Banking_App.app_id) | (→ Features.feature_id) | |
None | 1 | 1 |
None | 2 | 1 |
None | 3 | 1 |
None | 4 | 1 |
None | 5 | 1 |
None | 5 | 2 |