id | name | |
---|---|---|
1 | John Doe | johndoe@example.com |
2 | Jane Smith | janesmith@example.com |
3 | Michael Johnson | michaeljohnson@example.com |
4 | Emily Davis | emilydavis@example.com |
5 | David Brown | davidbrown@example.com |
id | customerId | balance |
---|---|---|
(→ Customers.id) | ||
1 | 1 | 0.0 |
2 | 2 | 0.0 |
3 | 3 | 0.0 |
4 | 4 | 0.0 |
5 | 5 | 0.0 |
id | accountId | cardNumber | expiryDate | securityCode | creditLimit |
---|---|---|---|---|---|
(→ Accounts.id) | |||||
1 | 1 | 1234567890123456 | 2023-12-31 | 123 | 5000.0 |
2 | 2 | 0987654321098765 | 2024-12-31 | 456 | 5000.0 |
3 | 3 | 1122334455667788 | 2025-12-31 | 789 | 5000.0 |
4 | 4 | 6655443322110099 | 2026-12-31 | 0 | 5000.0 |
5 | 5 | 9988776655443322 | 2027-12-31 | 111 | 5000.0 |
id | benefitName |
---|---|
1 | Rewards_Program |
2 | Travel Insurance |
3 | Extended Warranty |
4 | Purchase Protection |
5 | Price Protection |
id | creditCardId | benefitId |
---|---|---|
(→ Credit_Cards.id) | (→ Benefits.id) | |
1 | 1 | 1 |
2 | 2 | 1 |
3 | 3 | 1 |
4 | 4 | 1 |
5 | 5 | 1 |
6 | 5 | 4 |