EX4
Tables (4)
CUSTOMER (Untitled4)
- customerId (Key) — Primary key — NOT NULL
- name (Field)
- phone (Field2)
- address (Field3)
GENRE (Untitled2)
- genreId (Key) — Primary key — NOT NULL
- movieId (Key2) — Foreign key → MOVIE.movieId — NOT NULL
- genreId (Key22) — Foreign key → MOVIE.genreId — NOT NULL
- movieId (Key222) — Foreign key → MOVIE.movieId — NOT NULL
- name (Field)
- description (Field2)
MOVIE (Untitled)
- movieId (Key) — Primary key — NOT NULL
- genreId (Key2) — Foreign key → GENRE.genreId — NOT NULL
- movieId (Key22) — Foreign key → GENRE.movieId — NOT NULL
- title (Field)
- description (Field2)
RENT (Untitled3)
- rentId (Key) — Primary key — NOT NULL
- customerId (Key2) — Foreign key → CUSTOMER.customerId — NOT NULL
- rentDate (Field)
- returnDate (Field2)
- movieId (Key3) — Foreign key → MOVIE.movieId — NOT NULL
- genreId (Key22) — Foreign key → MOVIE.genreId — NOT NULL
- movieId (Key222) — Foreign key → MOVIE.movieId — NOT NULL