Acronym and Expansion Tables

• Tables:

  Acronym
  Name	Type	Properties	Notes
  expNpLc	CHAR(150)	Index key	Expansion without punctuations and lowercased
  exp	CHAR(180)	.	Expansion
  aType	CHAR(13)	.	Acronym or abbreviation
  acrNpLc	CHAR(70)	Index	acronym without punctuations and lowercased
  acr	CHAR(75)	.	Acronym

  Notes:
  The maximum length for expNpLc is 142. We use CHAR(150) for this column.
  The maximum length for exp is 169. We use CHAR(180) for this column.
  The maximum length for expNpLc is 12. We use CHAR(13) for this column.
  The maximum length for expNpLc is 67. We use CHAR(70) for this column.
  The maximum length for expNpLc is 71. We use CHAR(75) for this column.

• SQL Examples:

  • Find acronyms for "XXX"
    1. "xxx" = XXX.toLowerCase() and strip punctuation;
    2. SELECT acr FROM Acronym WHERE expNpLc = "xxx"

  • Find Expansions for "XXX"
    1. "xxx" = XXX.toLowerCase() and strip punctuation;
    2. SELECT exp FROM Acronym WHERE acrNpLc = "xxx"