考试
Tables (6)
AUTHOR (Untitled3)
- AuthorID (Key) — int — Primary key — NOT NULL
- BookID (Key2) — int — Foreign key → BOOK.BookID — NOT NULL
- ISBN (Key22) — int — Foreign key → BOOK.ISBN — NOT NULL
- name (Field) — char(30)
- address (Field2) — char(12)
BOOK (Untitled)
- BookID (Key) — int — Primary key — NOT NULL
- ISBN (Key2) — int — Primary key — NOT NULL
- year (Field) — char(30)
- PublisherID (Field2) — name
- KDC분류번호 (Field3) — char(50)
- PublisherID (Key3) — int — Foreign key → PUBLISHER.PublisherID — NOT NULL
- AuthorID (Key4) — int — Foreign key → AUTHOR.AuthorID — NOT NULL
- BookID (Key22) — int — Foreign key → AUTHOR.BookID — NOT NULL
- ISBN (Key222) — int — Foreign key → AUTHOR.ISBN — NOT NULL
- ID (Key5) — int — Foreign key → BOOK-AUTHOR.ID — NOT NULL
BOOK-AUTHOR (Untitled5)
- ID (Key) — int — Primary key — NOT NULL
- ISBN (Field) — int
- 주민번호 (Field2) — char(50)
KEYWORD (Untitled6)
- BookID (Key) — int — Foreign key → BOOK.BookID — NOT NULL
- ISBN (Key2) — int — Foreign key → BOOK.ISBN — NOT NULL
- SubjectID (Key3) — int — Foreign key → SUBJECT.SubjectID — NOT NULL
PUBLISHER (Untitled2)
- PublisherID (Key) — int — Primary key — NOT NULL
- name (Field) — char(15)
- address (Field2) — char(20)
- BookID (Key2) — int — Foreign key → BOOK.BookID — NOT NULL
- ISBN (Key22) — int — Foreign key → BOOK.ISBN — NOT NULL
SUBJECT (Untitled4)
- SubjectID (Key) — int — Primary key — NOT NULL
- name (Field) — char(30)
- description (Field2) — text