4번
테이블 (6)
Untitled (member)
- Key (member id) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(10)
- Field (adress) — char(10)
- Field
Untitled (dvd)
- Key (dvd code) — char(10) — 기본 키 — NOT NULL
- Field (purchase date) — date
- Field (number of rent) — char(10)
- Field (dvd name) — char(10)
- Field2 (price) — char(5)
- Key (movie id) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (movie)
- Key (movie id) — char(10) — 기본 키 — NOT NULL
- Field (title) — char(10)
- Field (pubyear) — char(10)
Untitled (rent)
- Key (member id) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (dvd code) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (rentdate) — char(1))
- Field (returndate) — char(10)
Untitled (casting)
- Key (role id) — char(1)) — 기본 키 — NOT NULL
- Field (role description) — char(10)
- Key (movie id) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (personid2) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (person)
- Key (personid) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(10)
- Field (description) — chary(10)
- Field