Because of a lapse in government funding, the information on this website may not be up to date, transactions submitted via the website may not be processed, and the agency may not be able to respond to inquiries until appropriations are enacted. The NIH Clinical Center (the research hospital of NIH) is open. For more details about its operating status, please visit cc.nih.gov. Updates regarding government operating status and resumption of normal operations can be found at OPM.gov.

Lexical Tools

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).