moviePJT
Tables (4)
forum_post (Comment)
- Key (uid) — int — Primary key — NOT NULL — 덧글 번호
- user_no (user) — int — Foreign key → user.user_no — NOT NULL
- Key (movie_id) — int — Foreign key → user.Key — NOT NULL
- user_no (user2) — int — Foreign key → user.user_no — NOT NULL
- Key (movie_id2) — int — Foreign key → user.Key — NOT NULL
- Field (content) — text
- Field (created_at) — Datetime
forum_thread (Review)
- Key (movie_id) — int — Foreign key → movie.Key — NOT NULL
- user_no (user2) — int — Foreign key → movie.user_no — NOT NULL
- Key (movie_id22) — int — Foreign key → movie.Key — NOT NULL
- Field (title) — char
- Field (content) — text
- Field (rank) — float
- Field (created_at) — Datetime
- Field (updated_at) — Datetime
- user_no (user) — int — Foreign key → user.user_no — NOT NULL
- Key (movie_id2) — int — Foreign key → user.Key — NOT NULL
movie (Movie)
- Key (movie_id) — int — Primary key — NOT NULL
- user_no (user2) — int — Foreign key → user.user_no — NOT NULL
- Key (movie_id2) — int — Foreign key → user.Key — NOT NULL
- Field (title) — char
- Field (release_date) — Date
- Field (popularity) — float
- Field (overview) — text
- Field (poster_path) — char
- Field (like_users) — int
user (accounts.User)
- user_no (user) — int — Primary key — NOT NULL
- Key (movie_id) — int — Foreign key → movie.Key — NOT NULL
- user_no (user2) — int — Foreign key → movie.user_no — NOT NULL
- Key (movie_id2) — int — Foreign key → movie.Key — NOT NULL
- Field