SH_JD_SCORES Table

  • I. Db Table

    SH_JD_SCORES
    NameTypePropertiesNotes
    shVARCHAR(3)Index, NOT NULLSub heading abbreviation (lower case)
    jidVARCHAR(6)Index, NOT NULLJournal descriptor ID
    scoreFLOAT scores based on document count for sub-heading

  • II. SQL Examples
    • Find scores for SH, "XXX"
      1. "xxx" = "XXX".toLowerCase( );
      2. SELECT jid, score FROM SH_JD_SCORES WHERE sh= 'xxx';