연습 문제 4
테이블 (6)
Untitled (Customer ID)
- Key (name) — int — 기본 키 — NOT NULL
- Field (address) — int
Untitled (DVD)
- Key (Movie Title) — chart(50) — 기본 키 — NOT NULL
- Field (Purchase Date) — int
- Field (Rental Count) — int
- Key (Movie Title2) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Movie ID)
- Key (Movie Title) — char(20) — 기본 키 — NOT NULL
- Field (Release Year) — int
- Key (Actor Name) — int — 외래 키 → Untitled2.Key — NOT NULL
- Key (Director Name) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (Director)
- Key (Director Name) — int — 기본 키 — NOT NULL
- Field (Director Biography) — int
Untitled (Rental)
- Key (Rental DateTime) — 기본 키 — NOT NULL
- Field (DVD Code) — int
- Field (Customer ID) — int
- Key (Movie Title) — chart(50) — 외래 키 → Untitled.Key — NOT NULL
- Key (name) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled2 (Actor)
- Key (Actor Name) — int — 기본 키 — NOT NULL
- Field (Actor Biography) — int