movie
Tables (9)
Comment (Untitled5)
- comment_pk — Integer — Primary key — NOT NULL
- reivew_pk (review_pk) — Integer — Foreign key → Review.reivew_pk — NOT NULL
- pk (pk2) — Integer — Foreign key → Review.pk — NOT NULL
- id — Integer — Foreign key → Review.id — NOT NULL
- id (id2) — Integer — Foreign key → User.id — NOT NULL
- content — Char
Genre (Untitled2)
- genre_id — Integer — Primary key — NOT NULL
- name — Char
Movie (Untitled3)
- pk — Integer — Primary key — NOT NULL
- title — Char
- original_title — Char
- release_date — Date
- popularity — Float
- vote_count — Integer
- vote_average — Float
- adult — Boolean
- overview — Text
- original_language — Char
- poster_path — Char
- backdrop_path — Char
Review (Untitled4)
- reivew_pk (review_pk) — Integer — Primary key — NOT NULL
- pk (pk2) — Integer — Foreign key → Movie.pk — NOT NULL
- id — Integer — Foreign key → User.id — NOT NULL
- title — Char
- content — Text
- rank — Integer
- created_at — Date
- updated_at — Date
- user (Field)
User (Untitled)
- id — Integer — Primary key — NOT NULL
- username — Char
genres (Untitled6)
- genre_id — Integer — Foreign key → Genre.genre_id — NOT NULL
- pk — Integer — Foreign key → Movie.pk — NOT NULL
hate_usres (hate_reviews)
- id — Integer — Foreign key → User.id — NOT NULL
- reivew_pk (review_pk) — Integer — Foreign key → Review.reivew_pk — NOT NULL
- pk (pk2) — Integer — Foreign key → Review.pk — NOT NULL
- id (id2) — Integer — Foreign key → Review.id — NOT NULL
like_users (like_movies)
- id — Integer — Foreign key → User.id — NOT NULL
- pk — Integer — Foreign key → Movie.pk — NOT NULL
like_users (like_reviews)
- id — Integer — Foreign key → User.id — NOT NULL
- reivew_pk (review_pk) — Integer — Foreign key → Review.reivew_pk — NOT NULL
- pk (pk2) — Integer — Foreign key → Review.pk — NOT NULL
- id (id2) — Integer — Foreign key → Review.id — NOT NULL