pjt
Tables (5)
accounts_user (Untitled)
- user_id — int — Primary key — NOT NULL
- username (사용자 이름) — varchar(50) — NOT NULL
- password (비밀번호) — varchar(50) — NOT NULL
community_review (Untitled3)
- review_id (PK) — int — Primary key — NOT NULL
- movie_id (FK2) — int — Foreign key → movies_movie.movie_id — NOT NULL
- user_id (FK) — int — Foreign key → movies_movie.user_id — NOT NULL
- title (제목) — varcher(50)
- content (내용) — text
- created_date (작성일) — date
- updated_date (수정일) — date
- like_review_users (좋아요) — manyTomany
communuty_comment (Untitled4)
- comment_id (PK) — int — Primary key — NOT NULL
- user_id (FK22) — int — Foreign key → accounts_user.user_id — NOT NULL
- review_id (FK2) — int — Foreign key → community_review.review_id — NOT NULL
- movie_id (FK) — int — Foreign key → community_review.movie_id — NOT NULL
- content (내용) — varchar(50)
- created_date (작성일) — date
- updated_date (수정일) — date
- like_comment_users (좋아요) — manyTomany
movies_movie (Untitled2)
- user_id (FK) — int — Primary key — NOT NULL
- movie_id (PK) — int — Primary key — NOT NULL
- title (제목) — varchar(50)
- overview (줄거리) — varchar(50)
- poster_path (포스터) — varchar(50)
- released_date (개봉일) — date
- genre (장르) — varchar(50)
rate (Untitled5)
- movie_id (FK) — int — Foreign key → movies_movie.movie_id — NOT NULL
- user_id (FK2) — int — Foreign key → movies_movie.user_id — NOT NULL
- score (평점) — float