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)