Organizations

IDName
1Global Corp
2Tech Inc.
3Financial Group
4Investment Holdings
5Bank Solutions

Board_Members

IDMemberNameRoleOrganizationID
(→ Organizations.ID)
1John SmithIndependent Director1
2Jane DoeIndependent Director3
3Michael JohnsonExecutive Manager1
4Emily BrownExecutive Manager2
5David WilsonNon-executive Director4

Customers

CustomerIDFirstNameLastNameDateOfBirthEmailAddressPhoneNumberAddressLine1AddressLine2CityStateZipCodeCountry
1AliceSmith1985-06-15alice@example.com+123456789123 Main St.New YorkNY10001USA
2BobJohnson1990-02-22bob@example.com+098765432456 Elm St.Los AngelesCA90001USA
3CarolWilliams1988-03-10carol@example.com+111222333789 Oak St.ChicagoIL60601USA
4DanielDavis1991-04-18daniel@example.com+44556677889246 Pine St.HoustonTX77001USA
5EvaMartin1992-05-25eva@example.com+9998877665321 Fir St.PhoenixAZ85001USA

Accounts

AccountIDCustomerIDBalanceType
(→ Customers.CustomerID)
115000.0Checking
223000.0Savings
334000.0Checking
442000.0Savings
551000.0Checking

Loans

LoanIDCustomerIDAmountInterestRateStartDateEndDateStatus
(→ Customers.CustomerID)
1115000.05.02022-01-012024-12-31Approved
2210000.04.52021-07-012023-06-30Disbursed
3320000.04.752020-01-012022-12-31Repaid
448000.05.252021-04-012023-03-31Pending
555000.04.752021-10-012023-09-30Denied