연습문제 4
테이블 (9)
Untitled (MOVIE)
- Key (movieID) — int(10) — 기본 키 — NOT NULL
- Field (title) — char(30)
- Field (pubYear) — int(4)
- Field (pubMonth) — int(2)
- Field (description) — LONGTEXT
- Field (award) — LONGTEXT
- Field (GPA) — filed
Untitled (DVDITEM)
- Key (itemID) — int(100) — 기본 키 — NOT NULL
- Field (buyingdate) — date
- Field (price) — int(10)
- Field (statusLevel) — char(1)
- Key (movieID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (CASTING)
- Key (roleID) — int(3) — 외래 키 → Untitled.Key — NOT NULL
- Key (personID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (movieID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (description) — text
Untitled (MOVIE_GENRE)
- Key (genreld) — int(5) — 외래 키 → Untitled.Key — NOT NULL
- Key (movieID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (GENRE)
- Key (genreld) — int(5) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (description) — LONGTEXT
Untitled (PERSON)
- Key (personID) — int(10) — 기본 키 — NOT NULL
- Field (fname) — char(30)
- Field (minit) — char(1)
- Field (Iname) — char(30)
- Field (description) — LONGTEXT
- Field (award) — text
Untitled (ROLE)
- Key (roleID) — int(3) — 기본 키 — NOT NULL
- Field (roletitle) — char(30)
- Field (description) — LONGTEXT
Untitled (RENT)
- Key (rentID) — int(1000) — 기본 키 — NOT NULL
- Field (rentDate) — date
- Field (retumDate) — date
- Key (clientID) — int(1000) — 외래 키 → Untitled.Key — NOT NULL
- Key (itemID) — int(100) — 외래 키 → Untitled.Key — NOT NULL
Untitled (CLIENT)
- Key (clientID) — int(1000) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (phone) — int(11)
- Field (email) — char(30)
- Field (address) — char(30)