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"
    1. SELECT * FROM Canonical WHERE unTerm = "xxx"
    2. Only one record should be found.