LexBuild

Add a New Record

Description:
  • Create a new lexical record from scratch.
  • User, Manager, Administrator

Logic Details:

StateDatabase tableSet LastActionDescriptions
Add
  • LEX_RECORD
  • LEX_RECORD_TEMP
  • INFL_VARS
  • INFL_VARS_TEMP
  •  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..
    SubmitLEX_RECORD_TEMP check if the record with specified EUI is pending (exist in LEX_RECORD_TEMP)
    SubmitLEX_RECORD_TEMP1(create)insert record into LEX_RECORD_TEMP
    SubmitINFL_VARS_TEMP Generate unique (var, infl, cat, cit, Eui, unInfl) inflVars and insert into INFL_VARS_TEMP
    ApproveLEX_RECORD_TEMP check if the record is Re-editing
    ApproveLEX_RECORD1insert record into LEX_RECORD
    ApproveLEX_RECORD_TEMP delete record from LEX_RECORD_TEMP with specified Eui & lastAction = 1
    ApproveINFL_VARS insert records with same Eui into INFL_VARS
    ApproveINFL_VARS_TEMP delete records from INFL_VARS_TEMP with specified Eui
    DenyLEX_RECORD_TEMP check if the record is Re-editing
    DenyLEX_RECORD_TEMP delete record in LEX_RECORD_TEMP with specified Eui and lastAction = 1
    DenyINFL_VARS_TEMP delete records in INFL_VARS_TEMP with specified Eui
    ViewLEX_RECORD_TEMP select all records in LEX_RECORD_TEMP with lastAction = 1