I have two tables, a simplified schema is like this:
Plan (plan_id, modified_time)
Plan_review(review_id, plan_id, eval_time, modify_time, submit_time, withdraw_time)
All of the above columns are bigint type. It is one to many relationship, so for one Plan record there may be multiple Plan_review records.
I need to update modified_time column in Plan table with the MAX value of the following columns in Plan_review table: eval_time, modify_time, submit_time, withdraw_time
The max value should be taken across all Plan_review records for a given plan_id.