This table stores information of lexicon.
| Field | Type | Null | Key | Default | Extra | Description |
|---|---|---|---|---|---|---|
| eui | VARCHAR(8) | No | PRI | 0 |   | EUI |
| base | VARCHAR(95) | No | Indexed |   |   | Base form |
| cat | INT |   |   |   |   | Category |
| lexRecrod | BLOB | No |   |   |   | Lexicon Record |
SQL Examples:
SELECT lexRecord from LEXICON WHERE eui = "eXXXXXXX"
This table stores all information for inflected variants. It was called as LRAGR.
| Field | Type | Null | Key | Default | Extra | Description |
|---|---|---|---|---|---|---|
| inflVar | VARCHAR(95) | No | PRI | 0 |   | Inflected varaints |
| cat | INT |   |   |   |   | Category |
| inflection | INT |   |   |   |   | Inflection |
| eui | VARCHAR(8) | No |   |   |   | EUI |
| unInfl | VARCHAR(95) | No |   |   |   | Uninflected (Base) form |
| citation | VARCHAR(95) | No |   |   |   | Citation (Unique base) form |
SQL Examples:
SELECT eui from INFL_VARS WHERE inflVar = "XXX"