연습문제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))