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

Inflection Tables

  • Tables:

    Inflection
    NameTypePropertiesNotes
    ifTermLCCHAR(105)PRIMARY KEYLowercase of Inflected Term
    ifTermCHAR(105).Inflected Term
    termCatINT.Category
    termInflLONG.Inflection
    euiCHAR(8)NOT NULL, IndexedEUI: Unique ID
    unTermCHAR(105).Uninflected Term
    unTermLCCHAR(105)IndexedLowercase of Uninflected Term
    ctTermCHAR(105).Citation Term

    Notes:
    The maximum length for ifTerm, ifTerm is 103. We use CHAR(105) for those columns.
    The maximum length for unTerm, ifTerm is 103. We use CHAR(105) for those columns.

  • SQL Examples:

    • Find inflected terms for "XXX"
      1. SELECT * FROM Inflection WHERE ifTermLC = "xxx"
      2. Filter out records if EUIs are duplicated
      3. SELECT * FROM Inflection WHERE eui = "xxxeui" AND unTerm = "xxxunTerm
      4. Add the ifTerms from all records.
      5. If none found, use trie (rules).

    • Find uninflected terms for "XXX"
      1. SELECT * FROM Inflection WHERE ifTermLC = "xxx"
      2. Add the unTerm if it does not exist in the output list.
      3. If none found, use trie (rules).

    • Find EUI of a term for "XXX"
      1. SELECT EUI FROM Inflection WHERE ifTermLC = "xxx"

    • Find EUI of an uninflected term for "XXX"
      1. SELECT EUI FROM Inflection WHERE unTerm = "xxx"

    • Find citation terms for "XXX"
      1. SELECT * FROM Inflection WHERE ifTermLC = "xxx"
      2. Add the ctTerm if it does not exist in the output list.