11
Tables (6)
Actor
- actor_id — INT
- actor_name — VARCHAR(100) — NOT NULL
Customer
- customer_id — INT
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(200)
- phone — VARCHAR(20)
DVD
- dvd_id — INT
- movie_id — INT — NOT NULL
Movie
- movie_id — INT
- title — VARCHAR(100) — NOT NULL
- genre — VARCHAR(50)
Movie_Actor
- movie_id — INT — Primary key — NOT NULL
- actor_id — INT — Primary key — NOT NULL
Rental
- rental_id — INT
- dvd_id — INT — NOT NULL
- customer_id — INT — NOT NULL
- rental_date — DATETIME