Final_PJT
Tables (9)
Comment (리뷰 댓글)
- id (Key) — integer — Primary key — NOT NULL
- content (Field) — varchar(100)
- created (Field2) — datetime
- updated (Field3) — datetime
- user_id (Key3) — integer — Foreign key → User.id — NOT NULL
- review_id (Key2) — integer — Foreign key → Review.id — NOT NULL
Genre (장르)
- id (Key) — integer — Primary key — NOT NULL
- name (Field) — char
Movie (영화)
- id (Key) — integer — Primary key — NOT NULL
- popularity (Field3) — real
- video (Field8) — boolean
- vote_count (Field4) — integer
- vote_average (Field5) — real
- title (Field) — varchar(100)
- release_date (Field2) — date
- original_language (Field9) — char
- original_title (Field10) — char
- backdrop_path (Field11) — text
- adult (Field12) — boolean
- overview (Field6) — text
- poster_path (Field7) — varchar(200)
Movie_Genre (영화/장르(M:N))
- id (Key) — integer — Foreign key → Genre.id — NOT NULL
- id (Key2) — integer — Foreign key → Movie.id — NOT NULL
OneLine (한줄평)
- id (Key) — integer — Primary key — NOT NULL
- title (Field1) — varchar(100)
- movie_title (Field2) — varchar(50)
- rank (Field3) — integer
- content (Field4) — text
- created_at (Field5) — datetime
- updated_at (Field6) — datetime
- user_id (Key2) — integer — Foreign key → User.id — NOT NULL
- id (Key3) — integer — Foreign key → Movie.id — NOT NULL
Oneline_Like (한줄평 좋아요(M:N))
- id (Key) — integer — Primary key — NOT NULL
- user_id (Key2) — integer — Foreign key → User.id — NOT NULL
- id (Key3) — integer — Foreign key → OneLine.id — NOT NULL
Review (영화 리뷰)
- id (Key) — integer — Primary key — NOT NULL
- title (Field1) — varchar(100)
- movie_title (Field2) — varchar(50)
- rank (Field3) — integer
- content (Field4) — text
- created_at (Field5) — datetime
- updated_at (Field6) — datetime
- user_id (Key2) — integer — Foreign key → User.id — NOT NULL
- id (Key3) — integer — Foreign key → Movie.id — NOT NULL
Review_Like (리뷰 좋아요(M:N))
- id (Key) — integer — Primary key — NOT NULL
- review_id (Key3) — integer — Foreign key → Review.id — NOT NULL
- user_id (Key2) — integer — Foreign key → User.id — NOT NULL
User (사용자)
- id (Key) — integer — Primary key — NOT NULL
- password (Field) — varchar(128)
- username (Field2) — varchar(150)
- email (Field3) — varchar(254)
- is_staff (Field5) — bool
- is_superuser (Field4) — bool
- is_active (Field6) — bool
- last_name (Field7) — varchar(150)
- first_name (Field8) — varchar(150)
- date_joined (Field9) — datetime
- last_login (Field10) — datetime