LexAccess - Database Tables
The database tables, LEX_RECORD and INFL_VARS, are duplicated from LexBuild. Some of the fields in these tables are not needed in LexAccess. These fields are kept to ease the integration on uploading the latest version of Lexicon data.
- TABLE - LEX_RECORD:
This table stores all information for all (approved) Lexical record in LEXICON. lastAction flag represent the status of last action.
- Create (1): records are new and created.
- Modify (2): records exist in Lexicon before and modified.
- Delete (3): records are deleted.
- Pending (4): records are submitted for modifying, deleting, restoring and waiting for approval.
- Restore (5): records were deleted and restored.
Field Type Null Key Default Extra Description eui VARCHAR(8) No PRI 0   EUI base VARCHAR(120) No Indexed     Base form category VARCHAR(5) No Indexed Noun   Category cSignature VARCHAR(20) No   None   Creation Signature mSignature VARCHAR(20) No   None   Modification Signature aSignature VARCHAR(20) No   None   Approval Signature lastAction INT No Indexed None(0)   Create(1)/Modify(2)/Delete(3)/Pending(4)/Restore(5) cDate VARCHAR(10) Yes   Null   Created date mDate VARCHAR(10) Yes   Null   Modified date aDate VARCHAR(10) Yes   Null   Approved date lexRecord VARCHAR(5000) No       Lexicon Record
SELECT lexRecord from LEX_RECORD WHERE eui = "ENNNNNNN"
- TABLE - INFL_VARS:
This table stores all inflectional variables of lexical records. This table is used for finding exact match and close match from an inflected term. LRAGR table presents same set of information as this table.
Field Type Null Key Default Extra Description inflVarLc VARCHAR(120) No indexed 0   Inflectional variables, lower case inflVar VARCHAR(120) No 0   Inflectional variables cat INT     0   Category inflection INT     0   Inflection eui VARCHAR(8) No Indexed 0   EUI unInfl VARCHAR(120) No   0   Uninflected variables, lower case citation VARCHAR(120)         Citation form*
SELECT eui from INFL_VARS WHERE inflVarLc = "xxx"
* A citation form is an arbitrary chosen form from all base forms. It is coded in the field of "base=" in the lexical record. Base forms are the uninflected forms of citation form and spelling variants.