v11.17.01
Tables (6)
Article (articles_article)
- Key (article_id) — integer — Primary key — NOT NULL
- movie_id — integer — Foreign key → Movie.Key — NOT NULL
- user_id — integer — Foreign key → User.Key — NOT NULL
- 리뷰제목 (title) — varchar(100)
- 리뷰상세 (content) — text
- 작성일 (created_at) — datetime
- 수정일 (updated_at) — datetime
Genre (movies_genre)
- Key (genre_id) — integer — Primary key — NOT NULL
- 장르 (name) — varchar(50)
Movie (movies_movie)
- Key (movie_id) — integer — Primary key — NOT NULL
- 영화제목 (title) — varchar(100)
- 개봉일 (released_date) — datetime
- 인기도 (popularity) — float
- 평점 (vote_avg) — float
- 줄거리 (overview) — text
- 포스터 (poster_path) — text
- 장르 (genres) — json
- 감독 (director) — varchar(50)
- 주/조연 (actors) — json
Movie_genre (Untitled)
- Key (id) — integer — Primary key — NOT NULL
- Key (movie_id) — integer — Foreign key → Movie.Key — NOT NULL
- Key (genre_id) — integer — Foreign key → Genre.Key — NOT NULL
Movie_info (Untitled2)
- Key (user_id) — integer — Foreign key → User.Key — NOT NULL
- Key (movie_id) — integer — Foreign key → Movie.Key — NOT NULL
- 정보 (info) — integer
User (accounts_user)
- Key (user_id) — integer — Primary key — NOT NULL
- 비밀번호 (password)
- ID (username) — varchar(150)
- 별명 (nickname) — varchar(20)
- 관리자계정 (is_superuser) — boolean