erd_1
Tables (9)
accounts_user (유저)
- user_id (Key) — integer — Primary key — NOT NULL
- password (pw) — text
- username (name) — text
- first_name (Field5) — text
- last_name (Field6) — text
- email (Field4) — text
- age (Field) — integer
- sex (Field2) — boolean
- preference (Field3) — integer
admin (관리자)
- admin_id (Key) — integer — Primary key — NOT NULL
- name (이름) — varchar()
- password (비번) — varchar()
community_comment (커뮤니티 댓글)
- user_id (Key2) — integer — Foreign key → accounts_user.user_id — NOT NULL
- review_id (Key3) — integer — Foreign key → community_review.review_id — NOT NULL
- content (Field) — varchar()
community_review (커뮤니티 리뷰)
- review_id (Key3) — integer — Primary key — NOT NULL
- user_id (Key) — integer — Foreign key → accounts_user.user_id — NOT NULL
- movie_id (Key2) — integer — Foreign key → movies_movie.movie_id — NOT NULL
- title (Field) — varchar()
- content (Field2) — varchar()
- rating (Field3) — integer
- created_at (Field4) — datetime
- updated_at (Field5) — datetime
movies_genre (영화장르)
- genre_id (Key2) — Primary key — NOT NULL
- movie_id (Key) — integer — Foreign key → movies_movie.movie_id — NOT NULL
- name (Field) — text
movies_genre_like (유저 선호 장르)
- user_id (Key) — integer — Foreign key → accounts_user.user_id — NOT NULL
- genre_id (Key2) — Foreign key → movies_genre.genre_id — NOT NULL
movies_movie (영화정보)
- movie_id (Key) — integer — Primary key — NOT NULL
- genre_id (Key23) — Foreign key → movies_genre.genre_id — NOT NULL
- adult (Field2) — boolean
- genres (Field) — array
- original_title (Field3) — text
- overview (Field4) — text
- popularity (Field5) — float
- poster_path (Field6) — text
- release_date (Field7) — text
- runtime (Key22) — integer — NOT NULL
- title (Key2) — text — NOT NULL
- vote_average (Field8) — float
- vote_count (Field9) — integer
movies_movie_dislike (영화 싫어요)
- user_id (Key) — integer — Foreign key → accounts_user.user_id — NOT NULL
- movie_id (Key2) — integer — Foreign key → movies_movie.movie_id — NOT NULL
movies_movie_like (영화 좋아요)
- movie_id (Key) — integer — Foreign key → movies_movie.movie_id — NOT NULL
- user_id (Key2) — integer — Foreign key → accounts_user.user_id — NOT NULL