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)