database 예제 4
테이블 (8)
Untitled (CUSTOMER)
- Key (memberID) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(50)
- Field (address) — dhar(50)
- Field (phone) — int(15)
Untitled (DVD)
- Key (registerID) — char(10) — 기본 키 — NOT NULL
- Field (purchaceDate) — date
- Field (numberOfRentals) — int(2)
- Key (movieID) — char(16) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MOVIE)
- Key (movieID) — char(16) — 기본 키 — NOT NULL
- Field (name) — char(50
- Field (productionYear) — int(4)
- Field (description) — text
- Field (runningTime)
- Field (genre)
- Field (grade)
Untitled (ACTOR)
- Key (actorID) — char(10) — 기본 키 — NOT NULL
- Field (biography) — text
Untitled (DIRECTOR)
- Key (directorID) — char(10) — 기본 키 — NOT NULL
- Field (biography) — text
Untitled (RENTAL_RECORD)
- Field (rentalDate) — date
- Field (returnDate) — date
- Key (memberID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (registerID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (APPEARENCE)
- Key (movieID) — char(16) — 외래 키 → Untitled.Key — NOT NULL
- Key (actorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (DIRECTION)
- Key (directorID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (movieID) — char(16) — 외래 키 → Untitled.Key — NOT NULL