movie
Tables (8)
articles (Untitled5)
- id (article_pk) — Primary key — NOT NULL
- username (account_id) — Foreign key → users.username
- title (제목)
- content (내용)
- created_at (생성일자)
- updated_at (수정일자)
- image (사진)
- Field
articles_like_users (Untitled7)
- username (user_id) — Foreign key → users.username
- id (article_pk) — Foreign key → articles.id — NOT NULL
comments (Untitled4)
- id (comment_id) — Primary key
- username (account_id) — Foreign key → users.username
- id (article_pk) — Foreign key → articles.id — NOT NULL
- content (내용)
- created_at (생성일자)
- updated_at (수정일자)
- Field
movies (Untitled2)
- id (movie_id) — Primary key
- poster_path (영화포스터)
- adult (나이제한)
- overview (줄거리)
- release_date (개봉일)
- genre_ids (장르)
- original_title (원제)
- original_language (원어)
- title (제목)
- popularity (인기)
- vote_count (투표수)
- vote_average (평점)
- video_path (유튜브 api)
- director (감독)
- actors (배우)
- Field
movies_like_users (Untitled8)
- username (user_id) — Foreign key → users.username
- id (movie_id) — Foreign key → movies.id
reviews (Untitled3)
- id (review_pk) — Primary key — NOT NULL
- username (account_id) — Foreign key → users.username
- id (movie_id) — Foreign key → movies.id
- content (내용)
- score (별점)
- created_at (생성일자)
- updated_at (수정일자)
- Field
reviews_like_users (Untitled6)
- username (user_id) — Foreign key → users.username
- id (review_pk) — Foreign key → reviews.id — NOT NULL
users (Untitled)
- username (user_id) — Primary key
- password (비밀번호)
- favorate_genre (선호장르)
- is_staff (관리자)
- age (나이)
- gender (성별)
- Field