Derivation Tables

• Tables:

  Derivation
  Name	Type	Properties	Notes
  termLc1	CHAR(99)	Index Key	Uninflected Term 1 in lowercase
  term1	CHAR(99)		Uninflected Term 1
  cat1	INT		Category 1
  eui1	CHAR(8)		EUI 1
  termLc2	CHAR(99)	Index	Uninflected Term 2 in LowerCase
  term2	CHAR(99)		Uninflected Term 2
  cat2	INT		Category 2
  eui2	CHAR(8)		EUI 2
  nagation	CHAR(1)		N|O for negative or otherwise derivation
  type	CHAR(1)		P|S|Z for prefix, suffix, or zero derivation
  prefix	CHAR(10)		prefix or "none" for suffixD and zeroD

  Notes:
  The maximum length for term1 is 96. We use CHAR(99) for this column.
  The maximum length for term2 is 96. We use CHAR(99) for this column.
  The maximum length for prefix is 8. We use CHAR(10) for this column.

• SQL Examples:

  • Find derivation for "XXX"
    1. "xxx" = XXX.toLowerCase();
    2. SELECT * FROM Derivation WHERE termLc1 = "xxx"
    3. SELECT * FROM Derivation WHERE termLc2 = "xxx"