Customer
id | firstName | lastName | email |
1 | John | Doe | john.doe@example.com |
2 | Jane | Smith | jane.smith@example.com |
Account
id | customerId | balance |
| (→ Customer.id) | |
1 | 1 | 1000.0 |
2 | 2 | 2000.0 |
PaymentPlan
id | accountId | paymentFrequency |
| (→ Account.id) | |
1 | 1 | Monthly |
2 | 2 | Quarterly |
PetInsurance
id | customerId | petName | coverageAmount | policyStartDate | policyEndDate |
| (→ Customer.id) | | | | |
1 | 1 | Max | 3000.0 | 2023-01-01 | 2026-01-01 |
2 | 2 | Bella | 4000.0 | 2023-07-01 | 2026-07-01 |
DisabilityInsurance
id | customerId | insuranceType | coverageAmount | policyStartDate | policyEndDate |
| (→ Customer.id) | | | | |
1 | 1 | Total | 5000.0 | 2023-01-01 | 2028-01-01 |
2 | 2 | Partial | 3000.0 | 2023-07-01 | 2029-07-01 |