Customers

CustomerIDFirstNameLastNameDateOfBirthEmailAddress
1JohnDoe1980-07-03john.doe@example.com
2JaneSmith1985-10-15jane.smith@example.com

Employees

EmployeeIDFirstNameLastNameHireDatePositionSalary
1AliceJohnson2015-06-01Manager60000.0
2BobWilliams2018-01-01Accountant50000.0

Balance_Sheet

IDBalanceAmountReportedDate
(→ Employees.HireDate)
11000000.02010-12-10
21200000.02011-01-05

Income_Statement

StatementIDTotalRevenueCostsNetProfitReportedDate
(→ Employees.HireDate)
11000000.0500000.0500000.02010-12-10
21200000.0600000.0600000.02011-01-05

Transactions

TransactionIDAmountTypeTransactionDateCustomerIDEmployeeID
(→ Customers.CustomerID)(→ Employees.EmployeeID)
11000.0Deposit2021-01-0111
2-500.0Withdrawal2021-01-0212