Nominalization Tables

• Tables:

  Nominalization
  Name	Type	Properties	Notes
  eui1	CHAR(8)	NOT NULL	EUI: Unique ID 1
  nomTerm1	CHAR(70)	Index key	Nominalization term 1
  cat 1	INT		Category
  eui2	CHAR(8)	NOT NULL	EUI: Unique ID 2
  nomTerm2	CHAR(70)	Index key	Nominalization term 2
  cat 2	INT		Category

  Notes:
  The maximum length for nomTerm1 is 69. We use CHAR(70) for this column.
  The maximum length for nomTerm2 is 68. We use CHAR(70) for this column.

• SQL Examples:

  • Find mapping lexicon terms for "XXX"
    1. SELECT nomTerm2 FROM Nominalization WHERE nomTerm1 = "xxx"
    2. SELECT nomTerm1 FROM Nominalization WHERE nomTerm2 = "xxx"