Canonical Tables

  • Tables:

    Canonical
    NameTypePropertiesNotes
    unTermCHAR(105)PRIMARY KEY Uninflected Term
    canTermCHAR(105). Canonical Term
    canonIdINT.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.