ERD 연습문제 4
테이블 (8)
Untitled (customer_dvd)
- Key (cCode) — char(10) — 외래 키 → customer.Key — NOT NULL
- Key (dCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (lentDate) — date
- Field (lentTime) — char(10)
Untitled (movie)
- Key (mCode) — char(10) — 기본 키 — NOT NULL
- Field (mName) — char(20)
- Field (mMadeDate) — date
- Field (mScore) — int(2)
- Key (alCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (dCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (dvd)
- Key (dCode) — char(10) — 기본 키 — NOT NULL
- Field (dBuyDate) — date
- Field (dNum) — int(5)
- Field (dLentNum) — int(5)
- Field
- Key (mCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (actor)
- Key (aCode) — char(10) — 기본 키 — NOT NULL
- Field (aName) — char(10)
- Field (aBirth) — date
- Field (aBiograpy) — text
- Key (alCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (actorList)
- Key (alCode) — char(10) — 기본 키 — NOT NULL
Untitled (director)
- Key (dCode) — char(10) — 기본 키 — NOT NULL
- Field (dName) — char(10)
- Field (dBiography) — text
Untitled (actorList_actor)
customer
- Key (cCode) — char(10) — 기본 키 — NOT NULL
- Field (cName) — char(5)
- Field (cAddress) — char(20)
- Field (cCell) — int(15)