중간고사2024

테이블 (8)

Untitled (Book)

  • Key (ISBN) — int — 기본 키 — NOT NULL
  • Field (boTitle) — char(30)
  • Field (boPublicationDate) — date
  • Key (pubID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (Publisher)

  • Key (pubID) — int — 기본 키 — NOT NULL
  • Field (pubName) — char(20)
  • Field (pubAddress) — text

Untitled (Author)

  • Key (AutID) — int — 기본 키 — NOT NULL
  • Field (autName) — char(20)
  • Field (autAddress) — text

Untitled (BookAuthor)

  • Key (ISBN) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (AutID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (Subject)

  • Key (subID) — int — 기본 키 — NOT NULL
  • Field (KDCNumber) — int
  • Field (subKeyword) — char(30)

Untitled (BookSubject)

  • Key (ISBN) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (subID) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (User)

  • Key (usID) — int — 기본 키 — NOT NULL
  • Field (usName) — char(20)
  • Field (usAddress) — text
  • Field (usPhoneNumber) — char(11)
  • Field (usEmail) — char(30)

Untitled (Loan)

  • Key (loanID) — int — 기본 키 — NOT NULL
  • Field (loanDate) — date
  • Field (loanReturnDate) — date
  • Key (usID) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (ISBN) — int — 외래 키 → Untitled.Key — NOT NULL