Customers

CustomerIDFirstNameLastNameEmailPhoneNumber
1JohnSmithjohnsmith@example.com+123456789
2JaneDoejanedoe@example.com+987654321
3AliceWonderlandalicemadness@example.com+135792468
4BobBuilderbobbythebuilder@example.com+246813579
5CharlieSheencharliessheen@example.com+357924681

CreditCards

CardIDCustomerIDCardNumberExpiryDateCVVCardLimit
(→ Customers.CustomerID)
111234-5678-9012-34562023-12-3112310000
219876-5432-1098-76542024-12-314565000
325678-9012-3456-12342023-06-1578915000
421357-9246-8135-79242024-06-1565410000
531478-5236-9851-12372023-11-3012320000
632468-1357-9246-81352024-11-3045615000

DebitCards

CardIDCustomerIDCardNumberExpiryDatePINCardLimit
(→ Customers.CustomerID)
111234-5678-9012-34562023-12-31111110000
219876-5432-1098-76542024-12-3122225000
325678-9012-3456-12342023-06-15333315000
421357-9246-8135-79242024-06-15444410000
531478-5236-9851-12372023-11-30555520000
632468-1357-9246-81352024-11-30666615000

Accounts

AccountIDCustomerIDBalanceCreatedAtUpdatedAt
(→ Customers.CustomerID)
115000.02024-03-13 18:51:312024-03-13 18:51:31
222000.02024-03-13 18:51:312024-03-13 18:51:31
331000.02024-03-13 18:51:312024-03-13 18:51:31
447500.02024-03-13 18:51:312024-03-13 18:51:31
553000.02024-03-13 18:51:312024-03-13 18:51:31

Transactions

TransactionIDAccountIDAmountTypeDate
(→ Accounts.AccountID)
11200.0Deposit2024-03-13 18:51:31
21-150.0Withdrawal2024-03-13 18:51:31
32400.0Deposit2024-03-13 18:51:31
42-300.0Withdrawal2024-03-13 18:51:31
53100.0Deposit2024-03-13 18:51:31
63-80.0Withdrawal2024-03-13 18:51:31
74500.0Deposit2024-03-13 18:51:31
84-200.0Withdrawal2024-03-13 18:51:31
95300.0Deposit2024-03-13 18:51:31
105-250.0Withdrawal2024-03-13 18:51:31