연습문제4번
테이블 (8)
Actor (Untitled5)
- actor_id (int(30)) — 기본 키
- name (char(30))
- biography (text)
Customer (Untitled)
- customer_id (int(6)) — 기본 키
- name (char(30))
- address (char(50))
DVD (Untitled3)
- dvd_id (int(6)) — 기본 키
- movie_id (int(6)2) — 외래 키 → Movie.movie_id
- movie_id (int(6)(FK))
- purchase_date (date)
- rental_count (int)
Director (Untitled6)
- director_id (int(6)) — 기본 키
- name (char(30))
- biography (text)
Movie (Untitled2)
- movie_id (int(6)) — 기본 키
- title (char(50))
- production_year (int(4))
Movie_Actor (Untitled7)
- movie_id (int(6)) — 기본 키
- actor_id (int(30)) — 기본 키
- movie_id (int(6)2) — 외래 키 → Movie.movie_id
- actor_id (int(30)2) — 외래 키 → Actor.actor_id
Movie_Director (Untitled8)
- movie_id (int(6)) — 기본 키
- director_id (int(6)(FK)) — 기본 키
- movie_id (int(6)2) — 외래 키 → Movie.movie_id
- director_id (int(6)3) — 외래 키 → Director.director_id
Rental (Untitled4)
- rental_id (int(6)(PK)) — 기본 키
- customer_id (int(6)2) — 외래 키 → Customer.customer_id
- dvd_id (int(6)3) — 외래 키 → DVD.dvd_id
- movie_id (int(6)22) — 외래 키 → DVD.movie_id
- customer_id (int(100)(FK))
- dvd_id (int(6)(FK))
- rental_date (date)
- rental_time (char(5))