Add a New Record
Description:Logic Details:
State | Database table | Set LastAction | Descriptions | ||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Add | | Check if the base of input term is in the LEX_RECORD or LEX_RECORD_TEMP by close match
| Edit | | | Edit 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_TEMP | 1(create) | 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 | 1 | insert record into LEX_RECORD
| Approve | LEX_RECORD_TEMP | | delete record from LEX_RECORD_TEMP with specified Eui & lastAction = 1
| Approve | INFL_VARS | | insert records with same Eui into INFL_VARS
| Approve | INFL_VARS_TEMP | | delete records from INFL_VARS_TEMP with specified Eui
| Deny | LEX_RECORD_TEMP | | check if the record is Re-editing
| Deny | LEX_RECORD_TEMP | | delete record in LEX_RECORD_TEMP with specified Eui and lastAction = 1
| Deny | INFL_VARS_TEMP | | delete records in INFL_VARS_TEMP with specified Eui
| View | LEX_RECORD_TEMP | | select all records in LEX_RECORD_TEMP with lastAction = 1
| |