ID | Name |
---|---|
1 | ABC Group |
2 | XYZ Corporation |
3 | Lemonade Financial Services |
4 | Pineapple Savings and Loan |
5 | Berry Investment Bank |
ID | FirstName | LastName | BirthDate | PhoneNumber | EmailAddress | CreatedAt | UpdatedAt | OrganizationID |
---|---|---|---|---|---|---|---|---|
(→ Organization.ID) | ||||||||
1 | John | Doe | 1985-06-15 | +1 (555) 123-4567 | john.doe@example.com | 2024-03-13 21:03:57 | 2024-03-13 21:03:57 | 1 |
2 | Jane | Smith | 1990-01-05 | +1 (555) 987-6543 | jane.smith@example.com | 2024-03-13 21:03:57 | 2024-03-13 21:03:57 | 2 |
3 | Alice | Wonderland | 1982-03-10 | +1 (555) 432-1234 | alice.wonderland@example.com | 2024-03-13 21:03:57 | 2024-03-13 21:03:57 | 3 |
4 | Robert | White | 1992-11-07 | +1 (555) 789-0123 | robert.white@example.com | 2024-03-13 21:03:57 | 2024-03-13 21:03:57 | 4 |
5 | Michael | Black | 1975-02-03 | +1 (555) 555-5555 | michael.black@example.com | 2024-03-13 21:03:57 | 2024-03-13 21:03:57 | 5 |
ID | Number | Type | Balance | InterestRate | DateOpened | IsActive | CustomerID |
---|---|---|---|---|---|---|---|
(→ Customer.ID) | |||||||
1 | 1234567890 | Checking | 1000.0 | 0.01 | 2022-01-01 | 1 | 1 |
2 | 9876543210 | Savings | 2000.0 | 0.02 | 2022-01-01 | 1 | 1 |
3 | 1112223334 | CD | 3000.0 | 0.03 | 2022-01-01 | 1 | 2 |
4 | 4445556667 | Loan | -2000.0 | 0.05 | 2022-01-01 | 0 | 2 |
5 | 7788901234 | Money Market | 5000.0 | 0.04 | 2022-01-01 | 1 | 3 |
ID | AccountID | CustodialService | TrustAdministration | StartDate | EndDate | PrincipalAmount | DistributionAmount | PaymentFrequency |
---|---|---|---|---|---|---|---|---|
(→ Account.ID) | ||||||||
1 | 1 | ABC Group | Xyz Trust Administration | 2010-01-01 | 2025-12-31 | 5000.0 | 3000.0 | Annually |
2 | 2 | XYZ Corporation | Pineapple Trust Company | 2015-01-01 | 2028-12-31 | 6000.0 | 3500.0 | Quarterly |
3 | 3 | Lemonade Financial Services | Berry Trust Management | 2012-01-01 | 2023-12-31 | 7000.0 | 4000.0 | Monthly |
4 | 4 | Pineapple Savings and Loan | ABC Trust Service | 2017-01-01 | 2026-12-31 | 8000.0 | 4500.0 | Biweekly |
5 | 5 | Berry Investment Bank | XYZ Trust Solutions | 2013-01-01 | 2022-12-31 | 9000.0 | 5000.0 | Semiannually |