Because of a lapse in government funding, the information on this website may not be up to date, transactions submitted via the website may not be processed, and the agency may not be able to respond to inquiries until appropriations are enacted. The NIH Clinical Center (the research hospital of NIH) is open. For more details about its operating status, please visit cc.nih.gov. Updates regarding government operating status and resumption of normal operations can be found at OPM.gov.
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.
This table stores all information for all (approved) Lexical record in LEXICON. lastAction flag represent the status of last action.
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"
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.