ERD 작성 연습

테이블 (13)

Actor (actor)

  • Actor Id (actor_id) — INT(8) — 기본 키 — NOT NULL
  • Actor Name (actor_name) — VARCHAR(20)

Comment (comment)

  • Comment Id (comment_id) — INT(8) — 기본 키 — NOT NULL
  • Content (content) — TEXT
  • Created At (created_at) — DATETIME
  • Updated At (updated_at) — DATETIME

Director (director)

  • Director Id (director_id) — INT(8) — 기본 키 — NOT NULL
  • Director Name (director_name) — VARCHAR(20)

Genre (genre)

  • Genre Id (genre_id) — INT(8) — 기본 키 — NOT NULL
  • Genre Name (genre_name) — VARCHAR(20)

Like Comment (like_comment)

  • Comment Id (comment_id) — INT(8) — 외래 키 → Comment.Comment Id — NOT NULL
  • User Id (user_id) — INT(8) — 외래 키 → User.User Id — NOT NULL

Movie (movie)

  • Movie Id (movie_id) — INT(8) — 기본 키 — NOT NULL
  • Movie Name (movie_name) — VARCHAR(20)
  • Show Time (show_time) — INT(3)
  • Production Year (prdt_year) — INT(4)
  • Comment Id (comment_id) — INT(8) — 외래 키 → Comment.Comment Id — NOT NULL

Movie Actor (movie_actor)

  • Movie Id (movie_id) — INT(8) — 외래 키 → Movie.Movie Id — NOT NULL
  • Actor Id (actor_id) — INT(8) — 외래 키 → Actor.Actor Id — NOT NULL

Movie Director (movie_director)

  • Movie Id (movie_id) — INT(8) — 외래 키 → Movie.Movie Id — NOT NULL
  • Director Id (director_id) — INT(8) — 외래 키 → Director.Director Id — NOT NULL

Movie Genre (movie_genre)

  • Movie Id (movie_id) — INT(8) — 외래 키 → Movie.Movie Id — NOT NULL
  • Genre Id (genre_id) — INT(8) — 외래 키 → Genre.Genre Id — NOT NULL

Movie Nation (movie_nation)

  • Movie Id (movie_id) — INT(8) — 외래 키 → Movie.Movie Id — NOT NULL
  • Nation Id (nation_id) — INT(8) — 외래 키 → Nation.Nation Id — NOT NULL

Nation (nation)

  • Nation Id (nation_id) — INT(8) — 기본 키 — NOT NULL
  • Nation Name (nation_name) — VARCHAR(20)

User (user)

  • User Id (user_id) — INT(8) — 기본 키 — NOT NULL
  • User Name (user_name) — VARCHAR(20)
  • Comment Id (comment_id) — INT(8) — 외래 키 → Comment.Comment Id — NOT NULL
  • Following (following_users) — INT(8) — 외래 키 → User.User Id — NOT NULL

Want Watch (want_watch)

  • Movie Id (movie_id) — INT(8) — 외래 키 → Movie.Movie Id — NOT NULL
  • User Id (user_id) — INT(8) — 외래 키 → User.User Id — NOT NULL