MovieProject
Tables (10)
Cast (Untitled6)
- cast_id (PK) — int — Primary key — NOT NULL
- name (배우이름) — char(100)
- character (배역이름) — char(100)
- movie_id (FK1) — int — Foreign key → Movie.movie_id — NOT NULL
- person_id (FK2) — int — Foreign key → Person.person_id — NOT NULL
Coment (Untitled10)
- comment_id (PK) — int — Primary key — NOT NULL
- community_id (FK1) — Foreign key → Community.Key — NOT NULL
- user_id (FK2) — int — Foreign key → User.user_id — NOT NULL
- content (댓글) — Text
Community (Untitled9)
- Key — Primary key — NOT NULL
- title (Field)
- content (Field2)
- movie_id (FK1) — int — Foreign key → Movie.movie_id — NOT NULL
- user_id (FK2) — int — Foreign key → User.user_id — NOT NULL
Crew (Untitled5)
- crew_id (PK) — int — Primary key — NOT NULL
- department (맡은 역할) — char(100)
- movie_id (FK1) — int — Foreign key → Movie.movie_id — NOT NULL
- person_id (FK2) — int — Foreign key → Person.person_id — NOT NULL
Emotion (Untitled3)
- emotion_id (Key) — int — Primary key — NOT NULL
- name (감정이름) — char(100)
Genre (Untitled2)
- genre_id (PK) — int — Primary key — NOT NULL
- name (장르이름) — char(100)
- movie_id (FK1) — int — Foreign key → Movie.movie_id — NOT NULL
- emotion_id (FK2) — int — Foreign key → Emotion.emotion_id — NOT NULL
Movie (Untitled)
- movie_id (PK) — int — Primary key — NOT NULL
- title (제목) — char(100)
- original_title (원어 제목) — char(100)
- release_date (개봉일) — Date
- overview (줄거리요약) — Text
- runtime (영화상영시간) — Time
- popularity (인기지수) — float
- vote_average (평균평점) — float
- vote_count (평점 투표 수) — int
- poster_path (포스터이미지경로) — char(200)
- backdrop_path (배경이미지경로) — char(200)
- budget (영화제작비용) — int
- revenue (영화수익) — int
- adult (성인영화여부) — bool
- genre_id (FK1) — int — Foreign key → Genre.genre_id — NOT NULL
- cast_id (FK2) — int — Foreign key → Cast.cast_id — NOT NULL
- review_id (FK3) — int — Foreign key → Review.review_id — NOT NULL
- crew_id (FK4) — int — Foreign key → Crew.crew_id — NOT NULL
Person (Untitled4)
- person_id (PK) — int — Primary key — NOT NULL
- name (이름) — char(100)
- biography (인물전기) — Text
- birthday (출생일) — Date
- deathday (사망일(option)) — Date
- profile_path (프로필이미지경로) — char(200)
- crew_id (FK1) — int — Foreign key → Crew.crew_id — NOT NULL
Review (Untitled7)
- review_id (PK) — int — Primary key — NOT NULL
- content (리뷰내용) — Text
- rating (평점) — float
- create_review (리뷰작성일) — DateTime
- user_id (FK1) — int — Foreign key → User.user_id — NOT NULL
- movie_id (FK2) — int — Foreign key → Movie.movie_id — NOT NULL
- emotion_id (FK3) — int — Foreign key → Emotion.emotion_id — NOT NULL
User (Untitled8)
- user_id (PK) — int — Primary key — NOT NULL
- user_email (이메일) — char(100)
- user_password (패스워드) — char(100)
- user_profile (유저이미지경로) — char(200)
- user_intro (유저소개) — char(100)
- review_id (FK1) — int — Foreign key → Review.review_id — NOT NULL
- comment_id (FK2) — int — Foreign key → Coment.comment_id — NOT NULL
- movie_id (ManyToMany) — int — Foreign key → Movie.movie_id — NOT NULL