ERD 연습문제 4
테이블 (8)
Untitled (movie)
- Key (mcode) — char(30) — 기본 키 — NOT NULL
- Field (myear) — int(4)
- Field (mname) — char(20)
Untitled (customer)
- Key (ccode) — char(30) — 기본 키 — NOT NULL
- Field (cname) — char(30)
- Field (cphone) — int(15)
- Field (caddress) — char(30)
Untitled (lentrecord)
- Key (rcode) — char(30) — 기본 키 — NOT NULL
- Field (rdate) — date
- Field (rtime) — char(30)
- Key (dcode) — char(30) — 외래 키 → dvd.Key — NOT NULL
- Key (ccode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (actor)
- Key (acode) — char(30) — 기본 키 — NOT NULL
- Field (aname) — char(30)
- Field (agender) — char(10)
Untitled (actorlist)
- Key (mcode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (acode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Field (lnum) — int(100)
Untitled (director)
- Key (dcode) — char(30) — 기본 키 — NOT NULL
- Field (dname) — char(30)
- Field (dgender) — char(2)
Untitled (directorlist)
- Key (mcode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (dcode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
dvd
- Key (dcode) — char(30) — 기본 키 — NOT NULL
- Field (dbuydate) — date
- Field (dlentnum) — int(5)
- Key (mcode) — char(30) — 외래 키 → Untitled.Key — NOT NULL