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