exam

Tables (6)

Untitled paper-author (Untitled5)

  • paperID (Key) — char(50) — Foreign key → paper.paperID — NOT NULL
  • authorID (Key2) — char(50) — Foreign key → author.authorID — NOT NULL
  • journalID (Key22) — char(50) — Foreign key → paper.journalID — NOT NULL

author (Untitled3)

  • authorID (Key) — char(50) — Primary key — NOT NULL
  • authorName (Field) — char(50)
  • background (Field2) — text
  • education (Field3) — text
  • Masterpiece (Field4) — text

journal (Untitled2)

  • journalID (Key) — char(50) — Primary key — NOT NULL
  • journalTitle (Field) — char(50)
  • journalAddress (Field2) — text
  • Addition (Field3) — text

member (Untitled4)

  • memberID (Key) — char(50) — Primary key — NOT NULL
  • Interests (Field) — text

paper (Untitled)

  • paperID (Key) — char(50) — Primary key — NOT NULL
  • journalID (Key2) — char(50) — Foreign key → journal.journalID — NOT NULL
  • paperAuthor (Field) — char(50)
  • paperTitle (Field2) — char(50)
  • paperAbstract (Field3) — text
  • paperJournal (Field4) — char(50)
  • paperIssue (Field5) — text
  • paperDOI (Field6) — int

paper-member (Untitled6)

  • paperID (Key) — char(50) — Foreign key → paper.paperID — NOT NULL
  • memberID (Key2) — char(50) — Foreign key → member.memberID — NOT NULL
  • journalID (Key22) — char(50) — Foreign key → paper.journalID — NOT NULL