exercise_4
Tables (9)
ACTOR (Untitled6)
- actorCode (Key) — char(15) — Primary key — NOT NULL
- actorName (Field) — char(20)
CUSTOMER (Untitled)
- customerID (Key) — char(15) — Primary key — NOT NULL
- customerName (Field) — char(20)
- customerAddress (Field2) — text
DIRECTOR (Untitled7)
- directorCode (Key) — char(15) — Primary key — NOT NULL
- directorName (Field) — char(20)
DVD (Untitled2)
- dvdCode (Key) — char(15) — Primary key — NOT NULL
- movieCode (Key3) — char(10) — Foreign key → MOVIE.movieCode — NOT NULL
- dvdRentedCount (Field) — int(5)
- dvdPurchasedDate (Field2) — date
- dvdDescription (Field3) — text
- dvdGenre (Field4) — char(30)
- originalDvdCode (Key2) — char(15) — Foreign key → DVD.dvdCode — NOT NULL
- movieCode (Key32) — char(10) — Foreign key → DVD.movieCode — NOT NULL
GENRE (Untitled9)
- genreID (Key) — char(20) — Primary key — NOT NULL
- genreName (Field) — char(20)
- genreDescription (Field2) — text
IS_RENTED (Untitled3)
- customerID (Key) — char(15) — Foreign key → CUSTOMER.customerID — NOT NULL
- dvdCode (Key2) — char(15) — Foreign key → DVD.dvdCode — NOT NULL
- movieCode (Key3) — char(10) — Foreign key → DVD.movieCode — NOT NULL
- rentedDate (Field) — date
- rentedTime (Field2) — float
MOVIE (Untitled4)
- movieCode (Key) — char(10) — Primary key — NOT NULL
- movieName (Field) — char(20)
- movieCreatedYear (Field2) — int(4)
- movieDescription (Field3) — text
MOVIE_GENRE (Untitled5)
- movieCode (Key) — char(10) — Foreign key → MOVIE.movieCode — NOT NULL
- genreID (Key2) — char(20) — Foreign key → GENRE.genreID — NOT NULL
PARTICIPATED_IN (Untitled8)
- movieCode (Key) — char(10) — Foreign key → MOVIE.movieCode — NOT NULL
- actorCode (Key2) — char(15) — Foreign key → ACTOR.actorCode — NOT NULL
- directorCode (Key3) — char(15) — Foreign key → DIRECTOR.directorCode — NOT NULL