SH_JD_SCORES Table

• I. Db Table

  SH_JD_SCORES
  Name	Type	Properties	Notes
  sh	VARCHAR(3)	Index, NOT NULL	Sub heading abbreviation (lower case)
  jid	VARCHAR(6)	Index, NOT NULL	Journal descriptor ID
  score	FLOAT		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';