Customers

customer_idfirst_namelast_nameemailphone_number
1JohnDoejohn.doe@example.com+123-456-7890
2JaneSmithjane.smith@example.com+098-765-4321
3MichaelBrownmichael.brown@example.com+456-789-0123
4AliceWhitealice.white@example.com+135-790-2468
5DavidBlackdavid.black@example.com+246-890-1357

Accounts

account_idcustomer_idaccount_typebalance
(→ Customers.customer_id)
1NoneChecking1000.0
2NoneSavings5000.0
3NoneCredit Card2000.0
4NoneLoan-1500.0
5NoneMortgage-20000.0

Mobile_Banking_App

app_idapp_versionrelease_dateplatform
1v1.02021-01-01Android
2v1.12021-05-01iOS
3v1.22021-07-01Android
4v1.32021-11-01iOS
5v1.42022-01-01Android

Features

feature_idfeature_value
1Mobile Deposit
2Bill Pay
3Person to Person Payment
4Fund Transfer between accounts
5Account Alerts

Mobile_Banking_App_Features

mobile_app_feature_idmobile_banking_app_idfeature_id
(→ Mobile_Banking_App.app_id)(→ Features.feature_id)
None11
None21
None31
None41
None51
None52