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

Canonical Tables

  • Tables:

    Canonical
    NameTypePropertiesNotes
    unTermCHAR(105)PRIMARY KEY Uninflected Term
    canTermCHAR(105). Canonical Term
    canonIdINT.Canonical Number

    Notes:

    • The maximum length for unTerm, canTerm are 103. We use CHAR(105) for those columns.
    • unTerm are lowercased, unique base form.

  • SQL Examples:

    • Find canonical terms for "XXX"
      1. SELECT * FROM Canonical WHERE unTerm = "xxx"
      2. Only one record should be found.