ERD연습_4
테이블 (7)
Untitled (CUSTOMER)
- Key (Id) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (address) — char(40)
- Field (phon) — integer(12)
Untitled (DVD)
- Key (dvdId) — char(10) — 기본 키 — NOT NULL
- Field (DOP) — integer(8)
- Field (rentNo) — integer(3)
- Field (copy) — char(1)
- Key (id) — char(6) — 외래 키 → Untitled.Key — NOT NULL
Untitled (RENTAL)
- Field (date) — integer(8)
- Field (time) — integer(4)
- Key (Id) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (dvdId) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (id) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MOVIE)
- Key (id) — char(6) — 기본 키 — NOT NULL
- Field (title) — char(30)
- Field (yearMade) — integer(4)
Untitled (ACTOR)
- Key (actId) — char(6) — 기본 키 — NOT NULL
- Key (id) — char(6) — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — char(30)
- Field (biography) — text
- Field (film) — text
Untitled (DIRECTOR)
- Key (dirId) — char(6) — 기본 키 — NOT NULL
- Key (id) — char(6) — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — char(30)
- Field (biography) — text
- Field (film) — text
Untitled (MENAGER)
- Key (id) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (phone) — integer(12)
- Field (workTime) — integer(10)