Clients

client_idnameaddressemailphoneNumber
1John Doe123 Main Stjohndoe@example.com555-1234
2Jane Smith456 Elm Stjanesmith@example.com555-5678

Accounts

account_idclient_idaccount_typebalance
(→ Clients.client_id)
11Checking1000.0
22Savings500.0

_Bank_Cards

card_idaccount_idcard_numbercard_expirycvv_bank_card_type
(→ Accounts.account_id)
1112345678901234562023-12-31123Credit Card
2109876543210987652024-01-15456Credit Card
3278901234567890122023-12-31789Debit Card
4245678901234567892024-01-1512Debit Card

Limits

limit_idcard_idcard_limit
(→ _Bank_Cards.card_id)
1110000.0
225000.0
3310000.0
445000.0