Acronym and Expansion Tables

  • Tables:

    Acronym
    NameTypePropertiesNotes
    expNpLcCHAR(130)Index key Expansion without punctuations and lowercased
    expCHAR(180). Expansion
    aTypeCHAR(13). Acronym or abbreviation
    acrNpLcCHAR(70)Indexacronym without punctuations and lowercased
    acrCHAR(75).Acronym

    Notes:
    The maximum length for expNpLc is 124. We use CHAR(130) 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"