Income table (income)
Id int primary key
Amount int income amount
Add_date dateTime income date

Spending table (extract)
Id int primary key
Apply_id int foreign keys: application Id
Add_date dateTime spending date

Application form (apply), the user application administrators to audit in the background after a spending increase information
Id int primary key

amount int the number of applicationsReview status int state (the default is agree to apply for the

For daily spending (extractAmount) total revenue (incomeAmount),
Total flow quantity (totalAmount=daily extractAmount + daily incomeAmount) history, add_date field is a dateTime type

CodePudding user response:

Could you speak more detailed point, is how to trigger, the trigger, or write in,