Modify an Existing Record
Description:Logic Details:
State | Database table | Set LastAction | Descriptions | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Select | | Select an existing record through Close Match or LexAccess
| Modify | | | Modify record: category, Spelling Vars, etc..
| 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 | 2 (modify) | insert record into LEX_RECORD_TEMP
| Submit | INFL_VARS_TEMP | | Generate unique (var, infl, cat, cit, Eui, unInfl) inflVars and insert into INFL_VARS_TEMP
| Approve | LEX_RECORD_TEMP | | check if the record is Re-editing
| Approve | LEX_RECORD | 2 | update record in LEX_RECORD
| Approve | LEX_RECORD_TEMP | | delete record from LEX_RECORD_TEMP with specified Eui & lastAction = 2
| Approve | INFL_VARS | | delete records from INFL_VARS with specified Eui
| Approve | INFL_VARS | | insert records to INFL_VARS from INFL_VARS_TEMP with specified Eui
| Approve | INFL_VARS_TEMP | | delete inflVars records from INFL_VARS_TEMP with specified Eui
| Deny | LEX_RECORD_TEMP | | check if the record is Re-editing
| Deny | LEX_RECORD | 2 | update record with Eui and lastAction = 4
| Deny | LEX_RECORD_TEMP | | delete record in LEX_RECORD_TEMP with Eui and lastAction = 2
| Deny | INFL_VARS_TEMP | | delete inflVars records from INFL_VARS_TEMP with specified Eui
| View | LEX_RECORD_TEMP | | select all records in LEX_RECORD_TEMP with lastAction = 2
| |