Synonyms Tables

• Tables:

  LexSynonym
  Name	Type	Properties	Notes
  keyFormNpLc	CHAR(80)	Index	Key word without punctuations and lowercased
  keyForm	CHAR(80)	.	Key Word
  cat1	int	.	Category of key
  aSynonym	CHAR(80)	.	synonym
  cat2	int	.	Category of synonym
  sSource	CHAR(8)	.	Source of synonym (CUI|EUI|ORG_LVG)

  Notes:
  The maximum length for keyFormNpLc is 71. We use CHAR(80) for this column.
  The maximum length for keyForm is 72. We use CHAR(80) for this column.
  The maximum length for synonym is 72. We use CHAR(80) for this column.

• SQL Examples:

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