4
Tables (9)
DVD-COPY (DVD_COPY)
- DVD-COPY_ID (DVD_COPY_ID) — INT — Primary key — NOT NULL
- dvdID — INT — Foreign key → dvd.dvdID — NOT NULL
Movie-Director Link (Movie_Director Link)
- movie_id — INT — Foreign key → movie.movie_id — NOT NULL
- director_id — INT — Foreign key → director.director_id — NOT NULL
actor
- actor_id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- biography — TEXT
customer
- customer_id — INT — Primary key — NOT NULL
- name — char(50) — NOT NULL
- address — char(50) — NOT NULL
director
- director_id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- biography — TEXT
dvd
- dvdID — INT — Primary key — NOT NULL
- purchase_date — DATE — NOT NULL
- movie_id — INT — Foreign key → movie.movie_id — NOT NULL
movie
- movie_id — INT — Primary key — NOT NULL
- title — VARCHAR(50) — NOT NULL
- year — INT — NOT NULL
movie-actor_Link (movie_actor_Link)
- movie_id — INT — Foreign key → movie.movie_id — NOT NULL
- actor_id — INT — Foreign key → actor.actor_id — NOT NULL
rental
- rental_date — DATETIME — NOT NULL
- rental_count — CHAR(50)
- customer_id — INT — Foreign key → customer.customer_id — NOT NULL
- DVD-COPY_ID (DVD_COPY_ID) — INT — Foreign key → DVD-COPY.DVD-COPY_ID — NOT NULL
- dvdID — INT — Foreign key → DVD-COPY.dvdID — NOT NULL