중간 시험

테이블 (8)

author_of_paper

  • paper_id (paper_id2) — INT — 외래 키 → papers.paper_id
  • author_id (author_id2) — INT — 외래 키 → authors.author_id

authors

  • author_id — INT — 기본 키
  • name — VARCHAR(100)
  • background — TEXT
  • degree_info — TEXT
  • representative_works — TEXT

interest_of_member

  • member_id (member_id2) — INT — 외래 키 → member.member_id
  • keywords_id (keywords_id2) — INT — 외래 키 → keywords.keywords_id

journals

  • journal_id — INT — 기본 키
  • name — VARCHAR(100)
  • address — TEXT
  • paper_id — INT — 외래 키 → papers.paper_id

keywords

  • keywords_id — INT — 기본 키
  • name — VARCHAR(100)

member

  • member_id — INT — 기본 키
  • name — VARCHAR(100)

paper_keywords

  • paper_id (paper_id2) — INT — 외래 키 → papers.paper_id
  • keywords_id (keywords_id2) — INT — 외래 키 → keywords.keywords_id

papers

  • paper_id — INT — 기본 키
  • title — VARCHAR(255)
  • abstract — TEXT
  • journal_id — INT
  • volume — INT
  • issue — VARCHAR(50)
  • doi — VARCHAR(100)