Lexical Tools
Canonical Tables
- Tables:
Canonical
|
Name | Type | Properties | Notes
|
unTerm | CHAR(105) | PRIMARY KEY | Uninflected Term
|
canTerm | CHAR(105) | . | Canonical Term
|
canonId | INT | . | Canonical Number
|
Notes:
- The maximum length for unTerm, canTerm are 103. We use CHAR(105) for those columns.
- unTerm are lowercased, unique base form.
- SQL Examples:
- Find canonical terms for "XXX"
- SELECT * FROM Canonical WHERE unTerm = "xxx"
- Only one record should be found.