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