마지막 과제

테이블 (12)

Untitled (Book)

  • Key (ISBN) — varchar(20) — 기본 키 — NOT NULL
  • Field (title) — varchar(255)
  • Field (publicationDate) — date
  • Key (publisherID) — int — 외래 키 → Untitled2.Key — NOT NULL

Untitled (Book_Author)

  • Key (ISBN) — varchar(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (authorID) — int — 외래 키 → Untitled3.Key — NOT NULL

Untitled (RelatedItem)

  • Key (itemID) — int — 기본 키 — NOT NULL
  • Field (type) — enum
  • Field (title) — varchar(255)
  • Field (description) — text

Untitled (Books_RelatedItems)

  • Key (ISBN) — varchar(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (itemID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (Author_NotableWorks)

  • Key (authorID) — int — 외래 키 → Untitled3.Key — NOT NULL
  • Key (workID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (NotableWorks)

  • Key (workID) — int — 기본 키 — NOT NULL
  • Field (title) — varchar(255)
  • Field (publicationDate) — date
  • Field (description) — tevt

Untitled2 (Publisher)

  • Key (publisherID) — int — 기본 키 — NOT NULL
  • Field (name) — varchar(255)
  • Field (address) — varchar(255)

Untitled3 (Author)

  • Key (authorID) — int — 기본 키 — NOT NULL
  • Field (name) — varchar(255)
  • Field (address) — varchar(255)

Untitled4 (Printer)

  • Key (printerID) — int — 기본 키 — NOT NULL
  • Field (name) — varchar(255)
  • Field (address) — varchar(255)

Untitled5 (Subject)

  • Key (subjectID) — int — 기본 키 — NOT NULL
  • Field (KDCNumber) — varchar(10)
  • Field (subjectName) — varchar(255)

Untitled6 (Book_Subject)

  • Key (ISBN) — varchar(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (subjectID) — int — 외래 키 → Untitled5.Key — NOT NULL

Untitled7 (Contract)

  • Key (ContractID) — int — 기본 키 — NOT NULL
  • Key (ISBN) — varchar(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (printerID) — int — 외래 키 → Untitled4.Key — NOT NULL
  • Field (printQuantity) — int
  • Field2 (deadline) — date