Movie_pjt
Tables (11)
Comment (movies_comment)
- id — PK — Primary key — NOT NULL
- user_id — FK — Foreign key → User.id — NOT NULL
- review_id — FK — Foreign key → Review.id — NOT NULL
- movie_id — FK — Foreign key → Review.movie_id — NOT NULL
- content (내용)
- created_at (생성시간)
- updated_at (수정시간)
Genre (movies_genre)
- id — PK — Primary key — NOT NULL
- name (장르 이름)
Movie (movies_movie)
- id — PK — Primary key — NOT NULL
- title (제목)
- original_title (개봉 제목)
- overview (요약)
- release_date (개봉일)
- popularity (관람객 수)
- vote_count (득표 수)
- vote_average (평점)
- adult (19금)
- poster_path (포스터)
- backdrop_path (배경이미지)
Movielist (movies_movielist)
- id — PK — Primary key — NOT NULL
- genre (장르)
- vote_average (평점)
Review (movies_review)
- id — PK — Primary key — NOT NULL
- movie_id — FK — Foreign key → Movie.id — NOT NULL
- user_id — FK — Foreign key → User.id — NOT NULL
- title (제목)
- content (내용)
- rank (요약)
- created_at (생성시간)
- updated_at (수정시간)
User (accounts)
- id — PK — Primary key — NOT NULL
- username (이름)
- password (비밀번호)
User (user_accounts)
- id — PK — Primary key — NOT NULL
- username (이름)
- password (비밀번호)
follow (accounts_user)
- id — PK — Primary key — NOT NULL
- from_user_id (보낸이) — FK — Foreign key → User.id — NOT NULL
- to_user_id (보내는이) — FK — Foreign key → User.id — NOT NULL
movie_genres (movie<->genre)
- id — PK — Primary key — NOT NULL
- genre_id — FK — Foreign key → Genre.id — NOT NULL
- movie_id — FK — Foreign key → Movie.id — NOT NULL
users_like (movie_users_like)
- id — PK — Primary key — NOT NULL
- movie_id — FK — Foreign key → Movie.id — NOT NULL
- user_id — FK — Foreign key → User.id — NOT NULL
users_like (review_user_like)
- id — PK — Primary key — NOT NULL
- review_id — FK — Foreign key → User.id — NOT NULL
- user_id — FK — Foreign key → Review.id — NOT NULL