Derivation Tables

  • Tables:

    Derivation
    NameTypePropertiesNotes
    termLc1CHAR(99)Index Key Uninflected Term 1 in lowercase
    term1CHAR(99) Uninflected Term 1
    cat1INT Category 1
    eui1CHAR(8) EUI 1
    termLc2CHAR(99)Index Uninflected Term 2 in LowerCase
    term2CHAR(99) Uninflected Term 2
    cat2INT Category 2
    eui2CHAR(8) EUI 2
    nagationCHAR(1) N|O for negative or otherwise derivation
    typeCHAR(1) P|S|Z for prefix, suffix, or zero derivation
    prefixCHAR(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"

  • Notes:
    Derivations should be symmetric (bi-directional). However, the data in this table is not symmetric. The symmetric feature is taken care of in the Java code when retrieving derivations from DB by two SQL queries (forward and backward).