Fruitful Variants Table

  • Table:

    Fruitful
    NameTypePropertiesNotes
    termLcCHAR(105)Index Key Term in lowercase
    lexTermCHAR(105). Input Term
    variantTermCHAR(170). Variants
    termCatINT. Category
    termInflLONG. Inflection
    orgCatINT. Original Category
    orgInflLONG. Original Inflection
    flowHistoryCHAR(25). Flow history
    distINT. Distance score
    tagInfoLONG. Tag information

    Notes:
    The maximum length for termLc is 103. We use CHAR(105) for this column.
    The maximum length for lexTerm is 103. We use CHAR(105) for this column.
    The maximum length for variantTerm is 169. We use CHAR(170) for this column.
    The maximum length for flowHistory is 23. We use CHAR(25) for this column.

  • SQL Examples:

    • Find fruitful variants for "XXX"
      1. "xxx" = XXX.toLowerCase();
      2. SELECT * FROM Fruitful WHERE termLc = "xxx"