4주차 연습문제 4번
테이블 (8)
Copy Of Untitled (DIRECTOR)
- Key (internalCode) — int — 기본 키 — NOT NULL
- Field (bioInfo) — text
Untitled (CUSTOMER)
- Key (customNo) — int — 기본 키 — NOT NULL
- Field (customName) — char(30)
- Field (address) — char(200)
Untitled (DVD)
- Key (dvdCode) — int — 기본 키 — NOT NULL
- Field (purchaseDate) — date
- Field (rentedNo) — int
- Key (identifier) — char(6) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MOVIE_TITLE)
- Key (identifier) — char(6) — 기본 키 — NOT NULL
- Field (movieTitle) — char(40)
- Field (releaseDate) — char(10)
Untitled (ACTOR)
- Key (internalCode) — int — 기본 키 — NOT NULL
- Field (bioInfo) — text
Untitled (CUSTOMER_DVD)
- Key (cstm_dvdNo) — int — 기본 키 — NOT NULL
- Field (rentedDate) — char(10)
- Field (rentedTime) — char(5)
- Key (customNo) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (dvdCode) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (MOVIE_ACTOR)
- Key (internalCode) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (identifier) — char(6) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MOVIE_DIRECTOR)
- Key (internalCode) — int — 외래 키 → Copy Of Untitled.Key — NOT NULL
- Key (identifier) — char(6) — 외래 키 → Untitled.Key — NOT NULL