돌담뮤비디아 최종 ERD
테이블 (12)
Actor
- actor_id — INTEGER — NOT NULL
- name — VARCHAR(50)
- poster_path — VARCHAR(200)
Diary
- diary_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
- date — DATE — NOT NULL
- mood_emoji — VARCHAR(100)
- title — VARCHAR(100)
- content — TEXT
- gpt_comment — TEXT
- recommend_movie_titles — JSON
- recommend_reasons — JSON
- analysis_emotion — TEXT
Diary_Like
- like_id — INTEGER — NOT NULL
- diary_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
Diary_comment
- comment_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- user_id — INTEGER — NOT NULL
- diary_id — INTEGER — NOT NULL
Genre
- genre_id — INTEGER — NOT NULL
- name — VARCHAR(50) — NOT NULL
Movie
- movie_id — INTEGER — NOT NULL
- title — VARCHAR(100) — NOT NULL
- release_date — DATE
- popularity — FLOAT
- vote_count — INTEGER
- vote_average — FLOAT
- overview — TEXT
- runtime — INTEGER
- production_country — VARCHAR(100)
- poster_path — VARCHAR(255)
- backdrop_path — VARCHAR(255)
- youtube_key — VARCHAR(100)
- director — VARCHAR(100)
- words — VARCHAR(255)
Movie_Actor
- movie_id — INTEGER — 기본 키 — NOT NULL
- actor_id — INTEGER — 기본 키 — NOT NULL
Movie_Genre
- movie_id — INTEGER — 기본 키 — NOT NULL
- genre_id — INTEGER — 기본 키 — NOT NULL
Movie_Like
- like_id — INTEGER — NOT NULL
- movie_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
Movie_comment
- comment_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- user_id — INTEGER — NOT NULL
- review_id — INTEGER — NOT NULL
Movie_review
- review_id — INTEGER — NOT NULL
- title — VARCHAR(255)
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- likes_count — INTEGER
- rating — INTEGER — NOT NULL
- movie_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
User
- user_id — INTEGER — NOT NULL
- username — VARCHAR(150) — NOT NULL
- name — VARCHAR(25)
- nickname — VARCHAR(100)
- stone — INTEGER
- profile_image — VARCHAR(255)
- visit_count — FLOAT
- is_public — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP