Synonyms Tables

  • Tables:

    LexSynonym
    NameTypePropertiesNotes
    keyFormNpLcCHAR(45)Index Key word without punctuations and lowercased
    keyFormCHAR(47).Key Word
    cat1int. Category of key
    aSynonymCHAR(47).synonym
    cat2int.Category of synonym

    Notes:
    The maximum length for keyFormNpLc is 44. We use CHAR(45) for this column.
    The maximum length for keyForm is 46. We use CHAR(47) for this column.
    The maximum length for synonym is 46. We use CHAR(47) for this column.

  • SQL Examples:

    • Find synonyms for "XXX"
      1. "xxx" = XXX.toLowerCase() and strip punctuation;
      2. SELECT aSynonym FROM LexSynonym WHERE keyFormNpLc = "xxx"