과제 예제6_임미숙
테이블 (5)
AUTHOR (Untitled3)
- Ssn (Key) — int — 기본 키 — NOT NULL
- ISBN (Key2) — int — 외래 키 → BOOK.ISBN — NOT NULL
- pub.ID (Key22) — char(10) — 외래 키 → BOOK.pub.ID — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(30)
- phone (Field3) — int
- email (Field4) — char(20)
BOOK (Untitled)
- ISBN (Key) — int — 기본 키 — NOT NULL
- pub.ID (Key2) — char(10) — 외래 키 → PUBLISHER.pub.ID — NOT NULL
- title (Field) — char(20)
- publishedDate (Field2) — date
- publisher (Field3) — char(15)
- author (Field4) — char(20)
- printer (Field5) — char(20)
CONTRACT (Untitled5)
- contractNo (Key) — char(10) — 기본 키 — NOT NULL
- ISBN (Key2) — int — 외래 키 → BOOK.ISBN — NOT NULL
- pub.ID (Key22) — char(10) — 외래 키 → BOOK.pub.ID — NOT NULL
- printerID (Key3) — char(10) — 외래 키 → PRINTER.printerID — NOT NULL
- QtyOfBook (Field) — char(10)
- printingdeadline (Field2) — char(15)
- contractdate (Field3)
PRINTER (Untitled4)
- printerID (Key) — char(10) — 기본 키 — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(30)
- phone (Field3) — int
- email (Field4) — char(20)
PUBLISHER (Untitled2)
- pub.ID (Key) — char(10) — 기본 키 — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(30)
- phone (Field3) — char(15)
- email (Field4)