By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version() |
---|
5.6.49 |
Employee_Id | Employee_Name | Job | Salary |
---|---|---|---|
1 | larry | null | 1000000.00 |
Salary_Transaction_Id | money_amount | Employee_Id |
---|---|---|
1 | 1000.00 | 1 |
Debt_alert_id | Salary_Transaction_Id | Remaining_money |
---|---|---|
1 | 1 | 999000.00 |
Salary_Transaction_Id | money_amount | Employee_Id |
---|---|---|
1 | 1000.00 | 1 |
2 | 2000.00 | 1 |
Debt_alert_id | Salary_Transaction_Id | Remaining_money |
---|---|---|
1 | 1 | 999000.00 |
2 | 2 | 998000.00 |