123

Tables (5)

Authors

  • AuthorsID (Key) — INT — Primary key — NOT NULL
  • Name — VARCHAR(255)
  • Education — VARCHAR(255)
  • Background — VARCHAR(255)
  • Masterpiece — VARCHAR(255)

Journals

  • JournalID (Key) — INT — Primary key — NOT NULL
  • Name — VARCHAR(255)
  • Address — VARCHAR(255)

Members

  • MemberID (Key) — INT — Primary key — NOT NULL
  • Name — VARCHAR(255)
  • Interests — VARCHAR(255)

PaperMembers

  • MemberID (Key) — INT — Foreign key → Members.MemberID — NOT NULL
  • PaperID (Key32) — INT — Foreign key → Papers.PaperID — NOT NULL

Papers

  • PaperID (Key3) — INT — Primary key — NOT NULL
  • Title — VARCHAR(255)
  • Abstract — TEXT
  • AuthorID — INT — Foreign key
  • JournalID — INT — Foreign key
  • Volume — INT
  • Issue — INT
  • DOI — VARCHAR(255)
  • Key — Foreign key → Authors.AuthorsID — NOT NULL
  • Key (Key2) — Foreign key → Journals.JournalID — NOT NULL