Fruitful Variants Table

• Table:

  Fruitful
  Name	Type	Properties	Notes
  termLc	CHAR(105)	Index Key	Term in lowercase
  lexTerm	CHAR(105)	.	Input Term
  variantTerm	CHAR(170)	.	Variants
  termCat	INT	.	Category
  termInfl	LONG	.	Inflection
  orgCat	INT	.	Original Category
  orgInfl	LONG	.	Original Inflection
  flowHistory	CHAR(70)	.	Flow history
  dist	INT	.	Distance score
  tagInfo	LONG	.	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 16. We use CHAR(70) for this column.

• SQL Examples:

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