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

  SQL Examples:
  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*

  SQL Examples:
  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.