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