exercise 4
Tables (6)
Untitled (CUSTOMER)
- Key (cusID) — char(10) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (address) — char(30)
- Field (phone) — char(11)
- Field (birthDate) — date
- Field (email) — char(30)
Untitled (DVD)
- Key (dvdCode) — char(20) — Primary key — NOT NULL
- Field (구입일) — date
- Field (대여횟수) — int(4)
- Field (movieName) — char(30)
- Field (price) — int(10)
- Key (movieId) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (RENT)
- Key (cusID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (대여날짜) — date
- Field (대여시간) — char(5)
- Key (dvdCode) — char(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (ACTOR_CASTING)
- Key (personId) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (movieId) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (MOVIE)
- Key (movieId) — int(10) — Primary key — NOT NULL
- Field (title) — chat(30)
- Field (pubYear) — int(4)
- Field (pubMonth) — int(2)
- Field (description) — LONGTEXT
- Field (award) — LONGTEXT
Untitled (PERSON)
- Key (personId) — int(10) — Primary key — NOT NULL
- Field (fname) — char(30)
- Field (minit) — char(1)
- Field (lname) — char(30)
- Field (description) — LONGTEXT
- Field (award) — text