MovieVibe
Tables (5)
Genre
- (genre_id) — int(1) — Primary key — NOT NULL
- (name) — Char
Movie
- (movie_id) — int(1) — Primary key — NOT NULL
- (genre_id) — int(1) — Foreign key → Genre.genre_id — NOT NULL
- (title) — Char
- Field2 (original_title) — Char
- Field3 (release_date) — Date
- Field4 (popularity) — Float
- Field5 (vote_count) — Integer
- Field6 (vote_average) — Float
- Field7 (adult) — Boolean
- Field8 (overview) — Text
- Field9 (original_language) — Char
- Field10 (poster_path) — Char
- Field (backdrop_path) — Char
Untitled (User)
- Key (user_id) — int(1) — Primary key — NOT NULL
- Field (username) — Char
- Field (password) — Char
- Field (profile_image) — Char
- Field (introduction) — Char
- Field
Untitled3 (Review)
- Key (review_id) — int(1) — Primary key — NOT NULL
- (movie_id) — int(1) — Foreign key → Movie.movie_id — NOT NULL
- (genre_id) — int(1) — Foreign key → Movie.genre_id — NOT NULL
- Field (movie)
- Field (user)
- Field (title) — Char
- Field (content) — Text
- Field (rank) — Integer
- Field (spoiler) — Boolean
- Field (created_at) — Date
- Field (updated_at) — Date
Untitled3 (Comment)
- Key (comment_id) — int(1) — Primary key — NOT NULL
- Field (review)
- Field (user)
- Field (content) — Char
- Field (created_at) — Date
- Field (updated_at) — Date