Customers
CustomerID | FirstName | LastName | DateOfBirth | EmailAddress |
1 | John | Doe | 1980-07-03 | john.doe@example.com |
2 | Jane | Smith | 1985-10-15 | jane.smith@example.com |
Employees
EmployeeID | FirstName | LastName | HireDate | Position | Salary |
1 | Alice | Johnson | 2015-06-01 | Manager | 60000.0 |
2 | Bob | Williams | 2018-01-01 | Accountant | 50000.0 |
Balance_Sheet
ID | BalanceAmount | ReportedDate |
| | (→ Employees.HireDate) |
1 | 1000000.0 | 2010-12-10 |
2 | 1200000.0 | 2011-01-05 |
Income_Statement
StatementID | TotalRevenue | Costs | NetProfit | ReportedDate |
| | | | (→ Employees.HireDate) |
1 | 1000000.0 | 500000.0 | 500000.0 | 2010-12-10 |
2 | 1200000.0 | 600000.0 | 600000.0 | 2011-01-05 |
Transactions
TransactionID | Amount | Type | TransactionDate | CustomerID | EmployeeID |
| | | | (→ Customers.CustomerID) | (→ Employees.EmployeeID) |
1 | 1000.0 | Deposit | 2021-01-01 | 1 | 1 |
2 | -500.0 | Withdrawal | 2021-01-02 | 1 | 2 |