Clients
client_id | name | address | email | phoneNumber |
1 | John Doe | 123 Main St | johndoe@example.com | 555-1234 |
2 | Jane Smith | 456 Elm St | janesmith@example.com | 555-5678 |
Accounts
account_id | client_id | account_type | balance |
| (→ Clients.client_id) | | |
1 | 1 | Checking | 1000.0 |
2 | 2 | Savings | 500.0 |
_Bank_Cards
card_id | account_id | card_number | card_expiry | cvv | _bank_card_type |
| (→ Accounts.account_id) | | | | |
1 | 1 | 1234567890123456 | 2023-12-31 | 123 | Credit Card |
2 | 1 | 0987654321098765 | 2024-01-15 | 456 | Credit Card |
3 | 2 | 7890123456789012 | 2023-12-31 | 789 | Debit Card |
4 | 2 | 4567890123456789 | 2024-01-15 | 12 | Debit Card |
Limits
limit_id | card_id | card_limit |
| (→ _Bank_Cards.card_id) | |
1 | 1 | 10000.0 |
2 | 2 | 5000.0 |
3 | 3 | 10000.0 |
4 | 4 | 5000.0 |