AntiNorm Tables

  • Tables:

    AntiNorm
    NameTypePropertiesNotes
    normTermCHAR(105)Index key Normalized term
    inflTermCHAR(105).Original inflectional term in lexicon
    termCatINT.Category
    termInflLONG.Inflection
    euiCHAR(8)NOT NULLEUI: Unique ID

    Notes:
    The maximum length for normTerm is 101. We use CHAR(105) for this column.
    The maximum length for inflTerm is 103. We use CHAR(105) for this column.

  • SQL Examples:

    • Find mapping lexicon terms for "XXX"
      1. SELECT inflTerm FROM AntiNorm WHERE normTerm = "xxx"