exercisen6-배미연
테이블 (5)
Author (Untitled3)
- AuthID (Key) — int(10) — 기본 키 — NOT NULL
- Name (Field) — char(30)
- AltermativeName (Field2) — char(30)
- SecurityNumber (Field3) — char(13)
- Address (Field4) — char(50)
- ISBN (Key2) — char(13) — 외래 키 → Book.ISBN — NOT NULL
Book (Untitled)
- ISBN (Key) — char(13) — 기본 키 — NOT NULL
- title (Field) — char(50)
- PubDate (Field2) — date
- Type (Field3) — char(10)
- price (Field4) — integer
- PubID (Key2) — char(10) — 외래 키 → Publisher.PubID — NOT NULL
Contract (Untitled5)
- Number (Key) — int — 기본 키 — NOT NULL
- Deadline (Field) — date
- description (Field2) — text
- PrintID (Key2) — char(10) — 외래 키 → Printer.PrintID — NOT NULL
Printer (Untitled4)
- PrintID (Key) — char(10) — 기본 키 — NOT NULL
- Name (Field) — char(30)
- Address (Field2) — char(50)
- Phone (Field3) — char(15)
- Email (Field4) — char(30)
- PubID (Key2) — char(10) — 외래 키 → Publisher.PubID — NOT NULL
Publisher (Untitled2)
- PubID (Key) — char(10) — 기본 키 — NOT NULL
- Name (Field) — char(30)
- Address (Field2) — char(50)
- Phone (Field3) — char(15)
- Email (Field4) — char(30)