Restore a delete record
Description:Logic Details:
State | Database table | Set LastAction | Descriptions |
---|---|---|---|
Select | LEX_RECORD | Select a record from deleted record list | |
Restore | Restore a deleted record | ||
Submit | LEX_RECORD_TEMP |   | check if the record with specified EUI is pending (exist in LEX_RECORD_TEMP) |
Submit | LEX_RECORD | 4 (Pending) | update record with specified Eui |
Submit | LEX_RECORD_TEMP | 5 (restore) | insert record into LEX_RECORD_TEMP |
Submit | INFL_VARS_TEMP | insert inflVars records (from INFL_VARS) into INFL_VARS_TEMP | |
Approve | LEX_RECORD | 5 | update record in LEX_RECORD |
Approve | LEX_RECORD_TEMP | delete record from LEX_RECORD_TEMP with specified Eui & lastAction = 5 | |
Approve | INFL_VARS_TEMP | delete inflVars records from INFL_VARS_TEMP with specified Eui | |
Deny | LEX_RECORD | 3 (Delete) | update record with Eui and lastAction = 4 |
Deny | LEX_RECORD_TEMP | delete record in LEX_RECORD_TEMP with Eui and lastAction = 5 | |
Deny | INFL_VARS_TEMP | delete inflVars records from INFL_VARS_TEMP with specified Eui | |
View | LEX_RECORD | select all records in LEX_RECORD with lastAction = 3 | |
View | LEX_RECORD_TEMP | select all records in LEX_RECORD_TEMP with lastAction = 5 |