Employees
emp_id | first_name | last_name | position | Board_Member | Organization |
1 | John | Doe | CEO | Executive Manager | Global Corp |
2 | Jane | Smith | CFO | Executive Manager | Global Corp |
3 | Mike | Brown | COO | Independent Director | Global Corp |
4 | Alice | Green | CTO | Independent Director | Not Global Corp |
Accounts
account_id | cust_id | balance |
| (→ Customers.cust_id) | |
1 | 1 | 1000.0 |
2 | 2 | 5000.0 |
3 | 3 | 2000.0 |
4 | 4 | 3000.0 |
5 | 5 | 7000.0 |
Transactions
transaction_id | account_id | amount | date |
| (→ Accounts.account_id) | | |
1 | 1 | 100.0 | 2021-01-01 12:00:00 |
2 | 1 | -50.0 | 2021-01-02 12:00:00 |
3 | 2 | 200.0 | 2021-01-01 13:00:00 |
4 | 2 | -100.0 | 2021-01-02 13:00:00 |
5 | 3 | 200.0 | 2021-01-01 14:00:00 |