FRBE 연습문제1

테이블 (4)

Untitled (Expression)

  • Key (exprID) — int(10) — 기본 키 — NOT NULL
  • Field (material) — text(30)
  • Field (technique) — text(30)
  • Field (size) — int(10)
  • Key (workID) — int(10) — 외래 키 → Work.Key — NOT NULL

Untitled (Manifestation)

  • Key (maniID) — int(10) — 기본 키 — NOT NULL
  • Field (date) — int(10)
  • Field (location) — char(30)
  • Field (edition) — char(20)
  • Key (exprID) — int(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Item)

  • Key (itemId) — int(10) — 기본 키 — NOT NULL
  • Field (condition) — char(20)
  • Field (uniqueID) — int(10)
  • Field
  • Key (maniID) — int(10) — 외래 키 → Untitled.Key — NOT NULL

Work

  • Key (workID) — int(10) — 기본 키 — NOT NULL
  • Field (title) — char(30)
  • Field (artist) — text(50)
  • Field (creationDate) — int(10)
  • Field (style) — text(30)