Organizations

org_idorganization
1ABC Group
2XYZ Company

Customers

customer_idfirst_namelast_namedate_of_birthphone_numberemailorg_id
(→ Organizations.org_id)
1JohnDoe1980-01-01555-1234john.doe@example.com1
2JaneSmith1975-06-15555-5678jane.smith@example.com2

Accounts

account_idaccount_typebalanceinterest_ratecustomer_id
(→ Customers.customer_id)
1Checking1000.00.011
2Savings5000.00.021

Transactions

transaction_iddescriptionamounttransaction_dateaccount_id
(→ Accounts.account_id)
1Initial Deposit1000.02024-03-13 15:09:161
2Monthly Interest Earned10.02024-03-13 15:09:161

Services

service_idfinancial_serviceorganization_id
(→ Organizations.org_id)
1Custodial Service1
2Custodial Service2
3Trust Administration1
4Trust Administration2