MH_JD_SCORES Table

  • I. Db Table

    MH_JD_SCORES
    NameTypePropertiesNotes
    mhVARCHAR(105)Index, NOT NULLMain heading (lower case)
    jidVARCHAR(6)Index, NOT NULLJournal descriptor ID
    scoreFLOAT scores based on document count for main heading

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