movie
Tables (5)
Copy Of Untitled (User)
- Key (id) — Integer — Primary key — NOT NULL
- Field (nickname) — string
- Field (password) — Date
- Field (email) — string
- Field (image) — string
- Field (userRating) — Integer
Untitled (Movie)
- Key (id) — Integer — Primary key — NOT NULL
- Field (title) — string
- Field (pubDate) — Date
- Field (country) — string
- Field (genre) — string
- Field (userRating) — Integer
- Field (actor) — string
- Field (director) — string
- Field (poster1) — string
- Field (poster2) — string
- Field (link) — string
- Field (runningTime) — Integer
Untitled (Review)
- Key (id) — Integer — Primary key — NOT NULL
- Field (title) — string
- Field2 (content) — string
- Field3 (created_at) — Date
- Field4 (updated_at) — Date
- Key (user_id) — Integer — Foreign key → Copy Of Untitled.Key — NOT NULL
- Key (movie_id) — Integer — Foreign key → Untitled.Key — NOT NULL
Untitled (Comment)
- Key (id) — Primary key — NOT NULL
- Field (content) — string
- Field2 (created_at) — Date
- Key (review_id) — Integer — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — Integer — Foreign key → Copy Of Untitled.Key — NOT NULL
Untitled (Movie_User)
- Key (movie_id) — Integer — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — Integer — Foreign key → Copy Of Untitled.Key — NOT NULL