ERD 연습문제4
테이블 (6)
Customers
- Key (customerNo) — int(6) — 기본 키 — NOT NULL
- Field (customerName) — char(20)
- Field (Address) — char(20)
Untitled (DVD)
- Key (copyCode) — int(6) — 기본 키 — NOT NULL
- Field (rentalCount) — int(6)
- Field (purchaseDate) — int(10)
- Key (DVDCode) — int(8) — NOT NULL
- Key (MovieID) — int(6) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Rental)
- Field (rentalDate) — int(10)
- Field (rentalTime) — int(20)
- Key (customerNo) — int(6) — 외래 키 → Customers.Key — NOT NULL
- Key (copyCode) — int(6) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Actor)
- Key (actorID) — int(6) — 기본 키 — NOT NULL
- Field (biography) — char(30)
- Key (MovieID) — int(6) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Movie)
- Key (MovieID) — int(6) — 기본 키 — NOT NULL
- Field (title) — char(30)
- Field (productionDate) — int(10)
- Key (directorID) — int(6) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Director)
- Key (directorID) — int(6) — 기본 키 — NOT NULL
- Field (biography)