CustomerID | FirstName | LastName | PhoneNumber | |
---|---|---|---|---|
1 | John | Smith | johnsmith@example.com | +123456789 |
2 | Jane | Doe | janedoe@example.com | +987654321 |
3 | Alice | Wonderland | alicemadness@example.com | +135792468 |
4 | Bob | Builder | bobbythebuilder@example.com | +246813579 |
5 | Charlie | Sheen | charliessheen@example.com | +357924681 |
CardID | CustomerID | CardNumber | ExpiryDate | CVV | CardLimit |
---|---|---|---|---|---|
(→ Customers.CustomerID) | |||||
1 | 1 | 1234-5678-9012-3456 | 2023-12-31 | 123 | 10000 |
2 | 1 | 9876-5432-1098-7654 | 2024-12-31 | 456 | 5000 |
3 | 2 | 5678-9012-3456-1234 | 2023-06-15 | 789 | 15000 |
4 | 2 | 1357-9246-8135-7924 | 2024-06-15 | 654 | 10000 |
5 | 3 | 1478-5236-9851-1237 | 2023-11-30 | 123 | 20000 |
6 | 3 | 2468-1357-9246-8135 | 2024-11-30 | 456 | 15000 |
CardID | CustomerID | CardNumber | ExpiryDate | PIN | CardLimit |
---|---|---|---|---|---|
(→ Customers.CustomerID) | |||||
1 | 1 | 1234-5678-9012-3456 | 2023-12-31 | 1111 | 10000 |
2 | 1 | 9876-5432-1098-7654 | 2024-12-31 | 2222 | 5000 |
3 | 2 | 5678-9012-3456-1234 | 2023-06-15 | 3333 | 15000 |
4 | 2 | 1357-9246-8135-7924 | 2024-06-15 | 4444 | 10000 |
5 | 3 | 1478-5236-9851-1237 | 2023-11-30 | 5555 | 20000 |
6 | 3 | 2468-1357-9246-8135 | 2024-11-30 | 6666 | 15000 |
AccountID | CustomerID | Balance | CreatedAt | UpdatedAt |
---|---|---|---|---|
(→ Customers.CustomerID) | ||||
1 | 1 | 5000.0 | 2024-03-13 18:51:31 | 2024-03-13 18:51:31 |
2 | 2 | 2000.0 | 2024-03-13 18:51:31 | 2024-03-13 18:51:31 |
3 | 3 | 1000.0 | 2024-03-13 18:51:31 | 2024-03-13 18:51:31 |
4 | 4 | 7500.0 | 2024-03-13 18:51:31 | 2024-03-13 18:51:31 |
5 | 5 | 3000.0 | 2024-03-13 18:51:31 | 2024-03-13 18:51:31 |
TransactionID | AccountID | Amount | Type | Date |
---|---|---|---|---|
(→ Accounts.AccountID) | ||||
1 | 1 | 200.0 | Deposit | 2024-03-13 18:51:31 |
2 | 1 | -150.0 | Withdrawal | 2024-03-13 18:51:31 |
3 | 2 | 400.0 | Deposit | 2024-03-13 18:51:31 |
4 | 2 | -300.0 | Withdrawal | 2024-03-13 18:51:31 |
5 | 3 | 100.0 | Deposit | 2024-03-13 18:51:31 |
6 | 3 | -80.0 | Withdrawal | 2024-03-13 18:51:31 |
7 | 4 | 500.0 | Deposit | 2024-03-13 18:51:31 |
8 | 4 | -200.0 | Withdrawal | 2024-03-13 18:51:31 |
9 | 5 | 300.0 | Deposit | 2024-03-13 18:51:31 |
10 | 5 | -250.0 | Withdrawal | 2024-03-13 18:51:31 |