영화추천
테이블 (7)
Community_Comments (Untitled4)
- id (PrimaryKey) — INT — 기본 키 — NOT NULL
- user_id (ForeignKey) — INT — 외래 키 → User.user_id — NOT NULL
- review_id (ForeignKey2) — INT — 외래 키 → Review.review_id — NOT NULL
- content (Field) — TEXT
Genre (Untitled8)
- genre_id (Primarykey) — INT — 기본 키 — NOT NULL
- genre_name (Field) — VARCHAR
Movie (Untitled7)
- movie_id (PrimaryKey) — INT — 기본 키 — NOT NULL
- poster_path (Field) — TEXT
- release_date (Field2) — DATE
- language (Field3) — VARCHAR
- vote_average (Field5) — FLOAT
- over_view (Field6) — TEXT
- popularity (Field7) — INT
Movie_Genre (Untitled9)
- id (Primarykey) — INT — 기본 키 — NOT NULL
- movie_id (ForeginKey) — INT — 외래 키 → Movie.movie_id — NOT NULL
- genre_id (ForeginKey2) — INT — 외래 키 → Genre.genre_id — NOT NULL
Review (Untitled3)
- review_id (PrimaryKey) — INT — 기본 키 — NOT NULL
- user_id (ForeignKey) — INT — 외래 키 → User.user_id — NOT NULL
- movie_id (ForeignKey2) — INT — 외래 키 → Movie.movie_id — NOT NULL
- title (Field) — VARCHAR
- rank (Field3) — FLOAT
- content (Field4) — Text
- created_at (Field5) — Date
- updated_at (Field6) — Date
User (Untitled)
- user_id (PrimaryKey) — INT — 기본 키 — NOT NULL
- user_name (Field) — CHAR
- password (Field2) — VARCHAR
User_Interest (Untitled2)
- user_id (PrimaryKey) — INT — 외래 키 → User.user_id — NOT NULL
- genre_id (ForeignKey) — INT — 외래 키 → Genre.genre_id — NOT NULL
- count (Field) — INT
- total (Field2) — FLOAT